Sum value from every 4 months

Question

excuse me, do you know the query to find the sum value from every 4 months?

Answer 1

Himas Adin Nugroho
For example table with price and day columns will look like this.

select sum(x.price) from dbo.price x
where datediff(month,getdate(),x.day)=4