medium10 pts · first answer countswindow-functionssqlrunning-totals

Running total that resets per customer

Which expression gives each customer's cumulative spend, restarting for every customer?

A.SUM(amount) OVER (ORDER BY customer_id, order_date ROWS UNBOUNDED PRECEDING)B.SUM(amount) OVER (PARTITION BY customer_id ORDER BY order_date ROWS UNBOUNDED PRECEDING)C.SUM(amount) OVER (PARTITION BY customer_id ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)D.SUM(amount) OVER (PARTITION BY order_date ORDER BY customer_id ROWS UNBOUNDED PRECEDING)

Discussion 0

Join free to post in the discussion.

Running total that resets per customer

Discussion 0

Related questions