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

Regional Signup-to-Order Ratio by Day | Algorithm

Medium

MediumjoinsSQL

Regional Signup-to-Order Ratio by Day

The marketing analytics team wants to understand how the ratio of new user signups to orders varies by region and day. They want to focus on days and regions where there were at least 10 orders, to avoid noisy ratios from low-activity periods.

Return

day : the date of activity region : the sales region signup_count : number of signups on that day (from signups table) orders : number of orders in that region on that day signup_per_order : the ratio of signups to orders (as a decimal) Only include rows where orders is at least 10. Order the results by day ascending, then region ascending.

Expected output

day	region	signup_count	orders	signup_per_order
2023-01-01	GB	33	10	3.3
2023-01-01	US	33	11	3
2023-01-02	DE	61	17	3.588235294117647

First 3 of 186 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 4 hints revealed

Submit an attempt first.