hard20 pts · first answer countswindow-functionssqlmoving-average
PRECEDING with a descending order
What does this frame cover for the row dated 10 March, assuming one row per day?
SUM(sales) OVER (ORDER BY sale_date DESC
ROWS BETWEEN 2 PRECEDING AND CURRENT ROW)Discussion 0
Join free to post in the discussion.