Running Revenue Total in SQL | Dataford Interview Questions

How would you calculate a running total of revenue by date in SQL?

Write a PostgreSQL query using the revenue_transactions table. Combine all transactions from the same date into one daily result, treating missing revenue as zero.

Output

One row per transaction date.
Columns: revenue_date, daily_revenue, and running_total.
Include every date present in the table and sort from earliest to latest date.

Schema

revenue_transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
revenue_date	DATE	Date on which the revenue transaction occurred
revenue	NUMERIC(12,2)	Revenue amount for the transaction

Your question is Running Revenue Total in SQL. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem