← All Exercises

Running Total with Window

intermediatesql~20min

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