SQL for Production Tracking | Dataford Interview Questions

Write a SQL query to track weekly production volume, labor hours, and completion rate by site.

Use the provided production, labor, and site records. Calculate weekly results using Monday as the start of the week, include weeks with production activity, and treat missing labor hours as zero.

Output

One row per site and production week.
Columns: site_id, site_name, week_start, production_volume, labor_hours, and completion_rate.
Include completion rate as a percentage, return NULL when planned production is zero, and order by site_id and week_start.

Schema

sites

Column	Type	Description
site_idPK	INT	Unique site identifier
site_name	VARCHAR(100)	Site name

production_records

Column	Type	Description
production_idPK	INT	Unique production record identifier
site_id	INT	Site where production occurred
production_date	DATE	Production activity date
planned_units	INT	Units planned for the production record
completed_units	INT	Units completed

labor_logs

Column	Type	Description
labor_log_idPK	INT	Unique labor log identifier
site_id	INT	Site where labor was recorded
work_date	DATE	Date labor was recorded
labor_hours	DECIMAL(8,2)	Hours worked

Your question is SQL for Production Tracking. Start with the requirements and the three tables 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