medium10 pts · first answer countssqlwindow-functions

Running total of sales

Which expression gives a running (cumulative) total of daily sales ordered by date?

A.SUM(sales) OVER (ORDER BY sale_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)B.SUM(sales) GROUP BY sale_dateC.SUM(sales) OVER (PARTITION BY sale_date)D.CUMSUM(sales) FROM daily_sales

← Latest order per customer What a p-value means →