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

Average Order Value on High Signup Days | Algorithm

Medium

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.

Tables · Analytics — Daily Metrics

daily_sales

dayTEXTpkregionTEXTpkrevenueREALordersINTEGER

day	region	revenue	orders
2023-01-01	US	490	10
2023-01-02	US	1028	21
2023-01-03	US	966	19
2023-01-04	US	1014	20
2023-01-05	US	1062	21

signups

dayTEXTpksignup_countINTEGER

0 of 4 hints revealed

Submit an attempt first.