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

Average Order Value on High Signup Days | Algorithm

MediumjoinsSQL

Average Order Value on High Signup Days

A marketing analyst needs to evaluate sales outcomes on days with strong user acquisition to assess the impact of high signups on revenue. For every day where at least 20 users signed up, provide a summary of overall sales activity, but only for days that are recorded in both the signups and daily_sales tables.

Return

day : the calendar day total_revenue : total sales revenue across all regions for that day total_orders : total number of orders across all regions for that day avg_order_value : average revenue per order for that day Include only days with signup_count of 20 or more, and list results in ascending order by day .

Expected output

day	total_revenue	total_orders	avg_order_value
2023-01-01	900	18	50
2023-01-02	1786	36	49.61111111111111
2023-01-03	1772	35	50.62857142857143

First 3 of 40 rows your query should return. Your column aliases don't need to match.

SQLite · Ctrl+Enter to run

Run your query to see results here.