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

Average Revenue per Signup by Day | Algorithm

MediumjoinsSQL

Average Revenue per Signup by Day

The marketing team needs a daily summary to assess how sales relate to new customer signups. For each day with at least one signup, provide the total revenue from all regions, the number of signups, and the average revenue per signup.

Return

day : the date total_revenue : total revenue across all regions for that day signup_count : number of signups on that day avg_revenue_per_signup : average revenue per signup on that day Include only days where signup_count is greater than zero, and order the results by day in ascending order.

Expected output

day	total_revenue	signup_count	avg_revenue_per_signup
2023-01-01	900	25	36
2023-01-02	1786	92	19.41304347826087
2023-01-03	1772	24	73.83333333333333

First 3 of 41 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.