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

MediumcaseSQL

Revenue Performance by Region Category

Regional managers want to quickly assess how each region is performing in terms of daily sales to prioritize support and recognize top performers. They need a breakdown of revenue for every region on each day, along with a clear label indicating whether that day's revenue was high, medium, or low based on set thresholds.

Return

day : the sales date region : the region name revenue : total revenue for that region and day performance_label : a label of 'High', 'Medium', or 'Low' based on revenue thresholds Include all days and regions, labeling each according to whether their revenue was above 10000 ('High'), between 5000 and 10000 inclusive ('Medium'), or below 5000 ('Low'). Order the results by day ascending, then region ascending.

Expected output

day	region	revenue	performance_label
2023-01-01	EU	410	Low
2023-01-01	US	490	Low
2023-01-02	EU	758	Low

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.

Revenue Performance by Region Category | Algorithm