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

Weekly Sales and Signup Summary by Region | Algorithm

Medium

Mediumdate-bucketingSQL

Weekly Sales and Signup Summary by Region

The regional sales manager needs a weekly summary to track both sales performance and new customer signups across all regions. This report will help identify which regions are driving revenue and attracting new users each week.

Return

region : the sales region year_week : the year and week label in 'YYYY-WW' format total_revenue : total revenue generated in that week total_orders : total number of orders in that week total_signups : total number of new signups in that week Include all region-week combinations where there were sales, even if there were no signups (showing signups as 0 in that case). Order the results by region and then by year_week ascending.

Expected output

region	year_week	total_revenue	total_orders	total_signups
DE	2023-00	467.5	9	33
DE	2023-01	5373.28	108	382
DE	2023-02	5736.23	116	413

First 3 of 35 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	550	11
2023-01-02	US	1010	20
2023-01-03	US	1020	20
2023-01-04	US	1030	21
2023-01-05	US	1040	21

signups

dayTEXTpksignup_countINTEGER

0 of 3 hints revealed

Submit an attempt first.