medium10 pts · first answer countswindow-functionssqlmoving-average
Value of a 3-row moving average
Daily orders are 10, 20, 30, 40 on four days. With AVG(orders) OVER (ORDER BY day ROWS BETWEEN 2 PRECEDING AND CURRENT ROW), what are the first two values?
Discussion 0
Join free to post in the discussion.