A monthly revenue report reads from a table with one row per month and region: the twelve months are values in a month column. The dashboard specification now requires one row per region with a separate output column for each month — Jan, Feb, and so on — each holding that month's revenue total. Which SQL capability produces this shape directly?

1. A. Hand-written conditional aggregation — twelve CASE WHEN expressions are the only way to reshape rows into columns in SQL, one per month 💬 A
2. B. PIVOT — it turns each distinct value of the month column into its own output column, with the aggregation applied in the same statement ✓ B
3. C. UNPIVOT — it rotates the month rows into columns and computes the aggregates while transposing the table 💬 C
4. D. explode — it expands the month values across the width of the result set, giving one column per month in a single pass 💬 D

Reveal answer

Correct answer: PIVOT — it turns each distinct value of the month column into its own output column, with the aggregation applied in the same statement

Reference: https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-functions