Rolling 3-Day Average | Dataford Interview Questions

Explain how you would write a SQL query to compute a rolling 3-day average using CTEs.

Use the daily_metrics table and treat missing calendar dates as having no metric value. The average should ignore NULL values.

Output

daily_metrics

Column	Type	Description
metric_idPK	INT	Unique metric record identifier
metric_date	DATE	Date on which the metric was recorded
active_users	INT	Number of active users recorded for the date

Your question is Rolling 3-Day Average. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Explain how you would write a SQL query to compute a rolling 3-day average using CTEs.

Use the daily_metrics table and treat missing calendar dates as having no metric value. The average should ignore NULL values.

daily_metrics

Column	Type	Description
metric_idPK	INT	Unique metric record identifier
metric_date	DATE	Date on which the metric was recorded
active_users	INT	Number of active users recorded for the date

Your question is Rolling 3-Day Average. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.