← All Exercises
Running Total with Window
intermediatesql
Background
Running totals are essential for cumulative metrics in financial and analytics dashboards.
Problem
Compute a running total of sales using SUM with window frame specification.
Input
Daily sales data
Output
Cumulative running total
Sample tests
Sample 1
Input: daily sales amounts
Expected: running total
Your solution
Learning objective
Learn window frames and analytical aggregations