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

Cumulative Revenue and Signups by Day and Region | Algorithm

Mediumrunning-totalSQL

Cumulative Revenue and Signups by Day and Region

Regional sales managers want to analyze both revenue and user acquisition trends over time. For each date and region, they need to see the daily revenue, the total revenue accumulated in that region up to that date, and the total number of signups accumulated across all regions up to that date.

Return

day : the date of the record region : the sales region revenue : the revenue for that region and day cumulative_region_revenue : the total revenue for the region from the start through that day cumulative_signups : the total number of signups from the start through that day (all regions) Include all records, and order the results by region and day .

Expected output

day	region	revenue	cumulative_region_revenue	cumulative_signups
2023-01-01	EU	410	410	25
2023-01-02	EU	758	1168	117
2023-01-03	EU	806	1974	141

First 3 of 82 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.