hard20 pts · first answer countssqlwindow-functionsdates

7-day average over missing days

daily_sales has one row per day with sales, but days with no sales have no row. What is wrong with calling this a 7-day moving average?

A.ROWS counts 7 rows, which can span more than 7 daysB.AVG cannot be used as a window functionC.ROWS BETWEEN only works with PARTITION BYD.The frame looks 6 rows ahead of the current row, not behind

Discussion 0

Join free to post in the discussion.

7-day average over missing days

Discussion 0

Related questions