SELECT * FROM SalesByQuarter
PIVOT
(
SUM (amount)

FOR quarter IN (Q1, Q2, Q3, Q4)
) AS P
ORDER BY YEAR DESC
a
b
c
d
e
