Running Total of Customer Spend

Problem

Write a query that, using a CTE that computes each order's total value (quantity times the product's price, via a join to products), returns customer_id, order_id, order_date, and a running_total column showing the cumulative spend per customer over time, ordered by customer_id then order_date.

Try It

Hint

Solution