WITH orders
AS
(
SELECT year, quarter, amount FROM SalesByQuarterID
)
SELECT * FROM orders
PIVOT
(
SUM (amount)
FOR quarter in (Q1, Q2, Q3, Q4)
) AS P
ORDER BY year
a
b
