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

7-Day Moving Average Revenue with Signups Comparison

Hardmoving-averageSQL

7-Day Moving Average Revenue with Signups Comparison

The executive team is reviewing how daily sales revenue aligns with user signups to inform marketing strategy. They need a daily summary that shows, for each date with user signups, the total revenue from all regions (if any), the number of new signups, and a 7-day moving average of total revenue to spot trends and anomalies over time.

Return

day : the date total_revenue : total sales revenue from all regions for that day (NULL if no sales) moving_avg_revenue : average daily total revenue over the current and previous 6 days (NULL if fewer than 7 days of data) signup_count : number of user signups on that day Show all days from the signups table, even if there were no sales, and order the results by day in ascending order.

Expected output

day	total_revenue	moving_avg_revenue	signup_count
2023-01-01	2255	2255	33
2023-01-02	4141	3198	61
2023-01-03	4182	3526	61

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.