Create a pivot table in SQL Server like the example below

Question

I have a SQL Server table with columns primary key (int), date (datetime), amount (int).

How can I create a pivot table like this?

Example Pivot table

user_1144035 · Answer

Are you looking for grouping sets?

select year(date), datepart(quarter, date), sum(amount)
from t
group by grouping sets ( (year(date), datepart(quarter, date)), (year(date)), () );