SQL Running Total | Advance SQL | Rolling N months SUM, AVG, MIN, MAX 

select year(order_date), month(order_date), sum(sales) , sum(sum(sales)) over(order by year(order_date), month(order_date) rows between 2 preceding and current row) , avg(sum(sales)) over(order by year(order_date), month(order_date) rows between 2 preceding and current row) , max(sum(sales)) over(order by year(order_date), month(order_date) rows between 2 preceding and current row) , min(sum(sales)) over(order by year(order_date), month(order_date) rows between 2 preceding and current row) from orders group by year(order_date), month(order_date) order by 1, 2

Thank you for your helpful explanation of rolling calculations!

Thank you so much. May you have all the success in your life 🙏🙏

Great 🎉

Good content. Can you please make more business scenario specific videos?

Hello Ankit, My name is Fozan I'm from Pakistan , your videos are very helpful please also make assignment questions, so that we can test our understanding.

Thanks for your clear instruction :D

Amazing😍

Nice video 👍

Very good explanation 🙂

Awsome

Does proceeding keyword is specific to Microsoft SQL Server or it would work across different RDBMS?

How to calculate the prior rolling 12 months average (current year = 2023, prior = 2022) -- I tried this: rows 24 preceding and 12 preceding

Also it will be very helpful if you can provide the data with each video to practice it also.

with cte as ( select datepart(year, order_date) as sales_year, datepart(month, order_date) as sales_month, sum(sales) as sales From cust_orders group by sales_year,sales_month) select *, sum(sales) over (order by sales_year asc, sales_month asc rows between 2 preceding and current row) as rolling_sum, min(sales) over (order by sales_year asc, sales_month asc rows between 2 preceding and current row) as rolling_min, max(sales) over (order by sales_year asc, sales_month asc rows between 2 preceding and current row) as rolling_max, avg(sales) over (order by sales_year asc, sales_month asc rows between 2 preceding and current row) as rolling_avg from cte;

Hi Ankit, how can we find rolling sum without using any windows function . Today, One interviewer has asked me this question. If anyone has any idea can share their thoughts.

Hi Ankit, Could you please provide data for this tutorial? I practice side by side as I go by the video. Thanks in advance.

Hi Ankit, A request... Could you please provide the schema of this query?

I am working on writing a query which will give the number of hours left on starting day and it should gradually decrease towards end day and reach zero. Can you please create a video for this?

9/142

how can we apply the same logic in postgre please help

Ankit bhai what does unbounded preceding and current following give.

Please make a video on NTILE, LAG and LEAD function also

please provide data ,create and insert stmt ,github or here

1:03 & 5:51 what is three sum?

how to get dataset

Please add the data

Sir Hume chotte bacche ko dekhna hai