SELECT year,
Q1 as [Quarter 1],
Q2 as [Quarter 2],
Q3 as [Quarter 3],
Q4 as [Quarter 4]
FROM SalesByQuarter
PIVOT
(
SUM (amount)
FOR quarter IN (Q1, Q2, Q3, Q4)
) AS P
ORDER BY YEAR DESC
a
b
