medium10 pts · first answer countswindow-functionssql

LAG on raw order rows

You want daily revenue change, but the table has many order rows per day. What should you do first?

A.Apply LAG on the raw rows, then GROUP BY dayB.Partition the LAG by dayC.GROUP BY day to one row per day, then apply LAGD.Order the LAG window by order_id

Discussion 0

Join free to post in the discussion.

LAG on raw order rows

Discussion 0

Related questions