easy5 pts · first answer countswindow-functionssqlmoving-average

A 3-day moving average frame

Daily sales have one row per day with no gaps. Which frame gives the average of today and the two previous days?

A.ROWS BETWEEN 3 PRECEDING AND CURRENT ROWB.ROWS BETWEEN CURRENT ROW AND 2 FOLLOWINGC.ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROWD.ROWS BETWEEN 2 PRECEDING AND CURRENT ROW

Discussion 0

Join free to post in the discussion.

A 3-day moving average frame

Discussion 0

Related questions