Thank you for your helpful explanation of rolling calculations!

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

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

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

Great 🎉

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

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

Nice video 👍

Amazing😍

Very good explanation 🙂

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

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.

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?

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

how can we apply the same logic in postgre please help

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

Awsome

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

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

Ankit bhai what does unbounded preceding and current following give.

how to get dataset

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

9/142

Please add the data

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;

Sir Hume chotte bacche ko dekhna hai