#0028

Running Revenue By Day

MediumSQL18 min15 XP

Problem

Given daily revenue rows, return each day with cumulative revenue up to that day.

Running totals show growth over time and are a core analytics dashboard pattern.

daily_sales(day, revenue)

Example 1

Inputday 1 revenue 100, day 2 revenue 50, day 3 revenue 200

Output100, 150, 350

Each running value includes all previous days plus the current day.

CodeSQL

SELECT
  day,
  revenue,
  -- running revenue
FROM daily_sales
ORDER BY day;

SELECT
  day,
  revenue,
  -- running revenue
FROM daily_sales
ORDER BY day;

Visible browser tests run here when available.

Testcases1 visible / 4 hidden categories

Three-day running total

Input100, 50, 200

Expected100, 150, 350

The window expands from the first row to the current row.

Hidden Test Categories

One day onlyZero revenue dayUnsorted inserted rowsRepeated revenue values