SQL: Calculate 7 Day Moving Average

Very clear, thanks

Nice video, thanks. Do you know if it is possible to do the same but creating a new calculated column in the database (not a query)? I am trying it but I get the following error: "You cannot use the window function 'avg' in this context".

skip the first minute - waste of time google sheeting

Thanks a lot for the amazing video, you really made it look easy. How to remove the average data prior 7 days ? since this is 7 days of moving average data, i want the field to show the data from the 7th day and 0or Null value from day 1-6. thanks for your help!

u made it look so easy.... thank u so much

Nice video
I have a question
How to show only period/days for max/the best moving average?

To the point. great video!