3-Row Moving Average of Daily Signups
Hard
window-functions
Meta
Spotify
LinkedIn
Calculate a 3-day moving average of daily user signups (current day plus the two preceding days). Return signup_date, signups, and moving_avg (rounded to 2 decimal places), ordered by signup_date.
Expected Output: Daily signups with 3-day rolling average.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...