Dataset Sales By Quarter
| Product | Sales | Quarter |
|---|---|---|
| Kale | 51 | Q1 |
| Kale | 23 | Q2 |
| Kale | 45 | Q3 |
| Kale | 3 | Q4 |
| Apple | 77 | Q1 |
| Apple | 0 | Q2 |
| Apple | 25 | Q3 |
| Apple | 2 | Q4 |
SELECT * FROM(
SELECT Product, Sales, Quarter FROM Shop.SalesByQuarter
)
PIVOT(
SUM(Sales) FOR Quarter IN ('Q1', 'Q2', 'Q3', 'Q4')
);
EXECUTE IMMEDIATE(
SELECT '''
SELECT * FROM(
SELECT Product, Sales, Quarter FROM Shop.SalesByQuarter
)
PIVOT(
SUM(Sales) FOR Quarter IN ("''' || STRING_AGG(DISTINCT Quarter, '","' ORDER BY Quarter) || '''")
)
'''
FROM Shop.SalesByQuarter
)