advancedWindow Functions 12m est

Cumulative Sales Running Total

Problem Statement

Calculate a cumulative running total of order sales revenue over time. Retrieve the `order_date`, the individual order's `total_amount`, and the running total aliased as `running_total`, sorted chronologically.

Skills Evaluated

Window FunctionsSUM OVERRunning Total
Write your SQL query in the editor on the right and click **Run Query**. The system runs your query and compares the result dataset with the official solution. Results must match row-for-row, column-for-column.

Expected Output Format

Executing expected result set...
SQL Query WorkspaceSQLite v3.45 (WASM Mode)
QUICK INSERT:
1