Hello all,

Question on SQL statement in MS SQL Server.

I have a database of Sales Analysis which contains the month of each transaction.

I want to group the qty sold quarterly, i.e Jan-Mar, Apr-Jun, Jul-Sep,Oct-Dec, sum it, and find the average by each quarter.

I understand that one of the way is to use CASE. Need help, a newbie.

Thank you all in advance. Really appreciate your help.