Hard
Window Functions
Running Total of Orders
Calculate a running total of order amounts ordered by date, showing each order and the cumulative total. Return columns: id, order_date, total_amount, running_total. Order results by: order_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS running_total FROM orders ORDER BY order_date.
Preparing the interactive SQL workspace...