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

Regional Revenue Growth vs. National Trend | Algorithm

Hardperiod-comparisonSQL

Regional Revenue Growth vs. National Trend

Regional managers want to benchmark their daily sales performance against overall company trends. They need to see, for each region and each day, how much revenue changed compared to the previous day for both that region and for the company as a whole.

Return

day : the date of the sales data region : the region name regional_revenue_change_pct : percent change in revenue for that region compared to its previous day national_revenue_change_pct : percent change in total company revenue compared to the previous day Show one row per region per day, ordered by day and then region . If there is no prior day to compare for a region or for the national total, display NULL for the change percentage.

Expected output

day	region	regional_revenue_change_pct	national_revenue_change_pct
2023-01-01	DE	NULL	NULL
2023-01-01	GB	NULL	NULL
2023-01-01	IN	NULL	NULL

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