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

Average Revenue per Order for High Signup Days | Algorithm

MediumaggregationSQL

Average Revenue per Order for High Signup Days

The marketing team wants to evaluate how sales performance correlates with high customer acquisition days. They are interested in each day where at least 100 new users signed up, and want to review the total signups, total revenue, total orders, and the average revenue per order for those days, aggregating sales across all regions.

Return

day : the date of activity signup_count : total number of new signups on that day total_revenue : combined revenue from all regions for that day total_orders : combined number of orders from all regions for that day avg_revenue_per_order : average revenue per order for that day Include only days with at least 100 signups, and order the results by day in ascending order.

Expected output

day	signup_count	total_revenue	total_orders	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.