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

Revenue Performance by Region Category | Algorithm

Medium

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.

Tables · Analytics — Daily Metrics

daily_sales

dayTEXTpkregionTEXTpkrevenueREALordersINTEGER

day	region	revenue	orders
2023-01-01	US	490	10
2023-01-02	US	1028	21
2023-01-03	US	966	19
2023-01-04	US	1014	20
2023-01-05	US	1062	21

signups

dayTEXTpksignup_countINTEGER

0 of 4 hints revealed

Submit an attempt first.