Moving Average Calculation | Dataford Interview Questions

Calculate a moving average for TaskRabbit metrics using SQL.

Use the taskrabbit_metrics table and calculate a three-observation moving average for completed_tasks. Ignore rows where the metric value is NULL.

Output

One row per completed_tasks observation.
Columns: metric_date, metric_name, and moving_average.
Round moving_average to two decimal places and order by metric_date ascending.

Schema

taskrabbit_metrics

Column	Type	Description
metric_idPK	INT	Unique metric observation identifier
metric_name	VARCHAR(100)	Name of the TaskRabbit metric
metric_date	DATE	Date of the metric observation
metric_value	DECIMAL(12,2)	Observed metric value

Your question is Moving Average Calculation. 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.

Problem