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

Average Revenue Per Order by Day with High Signups

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.

SQLite · Ctrl+Enter to run

Run your query to see results here.