Rolling 7-Day Production Average | Dataford Interview Questions

Write a SQL query utilizing window functions to calculate a rolling 7-day average of production output.

Use the production_output table. Treat dates without production records and NULL output values as zero. The rolling average should include the current date and the six preceding calendar dates.

Output

One row per calendar date from the minimum through maximum production date.
Columns: production_date, daily_output, and rolling_7_day_average.
Order by production_date ascending.

Schema

production_output

Column	Type	Description
production_idPK	INT	Unique production record identifier
production_date	DATE	Date of production
output_units	NUMERIC(10,2)	Units produced in the record

Your question is Rolling 7-Day Production 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.

Problem