Calculate the moving average of sales for each product over a 7-day window

In this video i have explained how to Calculate the moving average of sales for each product over a 7-day window.
dataset and solution:-
drive.google.c...
WINDOW FUNCTION VIDEO :- • Window Function
If you are interested in more such Lectures you can enroll in our upcoming course of Data Analytics .
For that contact me directly:-
On call : [phone]
On WhatsApp : [phone]
Connect with me on
LinkedIn - / pragya-rathi-8025b526a
WhatsApp Group - chat.whatsapp....
Topmate - topmate.io/let...

[@SunnySingh-mi8db]

superb plz comtimue this series

[@saijaswanth3036]

SELECT * , AVG(sale_amount) OVER(PARTITION BY product_id order by sale_date rows between 6 preceding and current row) AS avg_sale from sales_

[@saijaswanth3036]

given dataset file was wrong

[@InsightsLift]

drive.google.com/drive/u/0/mobile/folders/1t3KSRgj67R1imaUp5TAXZSFPYKIPeg37?usp=drive_link&pli=1