SELECT id, year, Q1, Q2, Q3, Q4 FROM SalesByQuarterID
PIVOT
(
SUM (amount)
FOR quarter IN (Q1, Q2, Q3, Q4)
) AS P
ORDER BY YEAR DESC
a
b
