JavaScript is required for SkillDojo AI to work properly. Please enable JavaScript and refresh the page.

Running Total Revenue and Signups by Day | Algorithm

Mediumrunning-totalSQL

Running Total Revenue and Signups by Day

Regional sales managers want to track daily performance alongside user growth to better understand how signups and revenue progress together. They need a report that, for each combination of day and region from the daily_sales table, shows the daily sales metrics together with new user signups and running totals.

Return

day (calendar day) region (sales region) revenue (total revenue for the day and region) orders (number of orders for the day and region) signup_count (number of new user signups on that day) running_total_revenue (cumulative revenue for the region up to and including that day) running_total_signups (cumulative signups across all days up to and including that day) Include only days and regions present in daily_sales . Results should be ordered first by region, then by day, both ascending.

Expected output

day	region	revenue	orders	signup_count	running_total_revenue	running_total_signups
2023-01-01	DE	467.5	9	33	467.5	33
2023-01-02	DE	858.5	17	61	1326	226
2023-01-03	DE	867	17	61	2193	531

First 3 of 203 rows your query should return. Your column aliases don't need to match.

SQLite · Ctrl+Enter to run

Run your query to see results here.