Postgres 9.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version


PostgreSQL 9.5.23 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit


create table points_reward(created timestamp, available_points int);
insert into points_reward values('2020-07-01',904);
insert into points_reward values('2019-07-01',930);
insert into points_reward values('2020-08-01',290);
insert into points_reward values('2019-08-01',90);
insert into points_reward values('2020-09-01',90);
insert into points_reward values('2019-09-01',90);
insert into points_reward values('2020-08-01',90);
insert into points_reward values('2019-07-01',90);
insert into points_reward values('2018-07-01',10090);
1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

select date_part('month', points_reward.created) as "Month",
   sum(available_points) filter (where date_part('year', points_reward.created)=2019) "2019",
   sum(available_points) filter (where date_part('year', points_reward.created)=2020) "2020"
from points_reward
group by 1


Month
2019
2020


9
90
90

7
1020
904

8
90
380