Search: "between"
Convert between rows and columns - Data Lake Analytics Documentation
Convert rows to columnsMethod 1: Use the CASE WHEN clauseSELECT username, max(CASE WHEN subject ...