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