Skip to main content
All Problems
hard0% acceptance

Running Total of Daily Order Revenue

Produce a daily revenue report with a running total. For each order_date, show the date, the daily revenue (sum of total_amount), and the cumulative running total across all dates. Sort by order_date.

Schema

🔑idINT
🔗customer_idINT
order_dateTEXT
statusTEXT
total_amountREAL
postgresql

Run your query to see results

Press Ctrl + Enter to execute