SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
drop table if exists Sales;

create table Sales
(
    ProductID int,
    Date date,
    Amount int,
);
insert into Sales (ProductID, Date, Amount)
values
(101, '2024-01-10', 300),
(101, '2024-12-15', 500),
(101, '2025-01-15', 700),
(101, '2025-02-01', 1100),
(102, '2024-02-20', 800),
(102, '2024-11-03', 400),
(102, '2025-01-20', 900),
(102, '2025-02-22', 650),
(103, '2023-07-25', 1200),
(103, '2024-08-15', 1500),
(103, '2025-02-10', 1250),
(104, '2023-12-05', 400),
(104, '2024-06-30', 800),
(104, '2025-01-30', 300),
(104, '2025-02-25', 500);
15 rows affected

select
    ProductID
    ,sum(iif(year(Date)=2023, Amount, null)) as [2023]
    ,sum(iif(year(Date)=2024, Amount, null)) as [2024]
    ,sum(iif(year(Date)=2025, Amount, null)) as [2025]
from Sales
group by ProductID;


ProductID
2023
2024
2025


101
null
800
1800

102
null
1200
1550

103
1200
1500
1250

104
400
800
800


Warning: Null value is eliminated by an aggregate or other SET operation.


select 
    * 
from (
    select 
        ProductID, 
        year(Date) as Year, 
        Amount 
    from Sales
) as ToPivotSales pivot (
    sum(Amount) for Year in ([2023], [2024], [2025])
) as PivottedSales


ProductID
2023
2024
2025


101
null
800
1800

102
null
1200
1550

103
1200
1500
1250

104
400
800
800


declare
    @cols as nvarchar(max),
    @query as nvarchar(max);


select @cols = string_agg(quotename(Year), ',') within group (order by Year)
from (select distinct year(Date) as Year from Sales) as YearList;


set @query = (
    'select *
    from (
        select ProductID, year(Date) as Year, Amount
        from Sales
    ) as ToPivotSales pivot (
        sum(Amount) for Year in (' + @cols + ')
    ) as PivotedSales;'
);


exec sp_executesql @query;


ProductID
2023
2024
2025


101
null
800
1800

102
null
1200
1550

103
1200
1500
1250

104
400
800
800
ProductID	2023	2024	2025
101	null	800	1800
102	null	1200	1550
103	1200	1500	1250
104	400	800	800