All SQL problems
HardWindow
Running order revenue over time
For each delivered order, return (order id, order date, order revenue, running total revenue up to and including that order). Use a window function.
- #window
- #running-total
- #sum-over
Schema (SQLite, in-browser)
customers (id, name, city, signup_date) products (id, name, category, price) orders (id, customer_id, order_date, status) order_items (order_id, product_id, quantity)
Sample input
delivered orders in order_date order
Expected shape
one row per delivered order
sql-running-total.sqlSQLite
Result
Press “Run query” to execute against the sample database.