I am trying to create a query\procedure that will show the total number of orders from a selected customer in 6 month intervals. For 6, 12, 18 and 24 months. Please show a step by step.
example if abc company order 6 times from Jan to Jun and 4 times from Jul-Dec then i want the report to show
company 6_Months 12_Months
acbc 6 10 <----- Rolling sum
I am using microsoft sql server 14