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

Average Revenue Per Order by Day with High Signups

Medium

MediumaggregationSQL

Average Revenue Per Order by Day with High Signups

The marketing team wants to evaluate how efficiently revenue is generated on days with high customer signups. For each day when at least 100 new users signed up, they need to know the average revenue earned per order across all regions.

Return

day : the calendar date avg_revenue_per_order : average revenue per order for that day (across all regions) Include only days where signup_count is at least 100, and order the results by day in ascending order.

Expected output

day	avg_revenue_per_order
1 row — values hidden, that's the puzzle

Your query should return 1 row with these columns. 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.