medium10 pts · first answer countswindow-functionssql

Year-over-year with LAG 12

Monthly sales use LAG(sales, 12) OVER (PARTITION BY store ORDER BY month) for year-over-year. A new store has no rows for its two closed months. What is the risk?

A.LAG cannot use an offset larger than 10B.LAG 12 lands on the wrong month for later rowsC.The partition resets every 12 rowsD.There is no risk; LAG reads dates, not rows

Discussion 0

Join free to post in the discussion.

Year-over-year with LAG 12

Discussion 0

Related questions