SQL Throughput by Facility vs Target | Dataford Interview Questions

Write a SQL query to calculate daily processing throughput by facility and compare it to target.

Use the provided facility, processing event, and daily target data. Throughput is the total units from completed events only.

Output

One row per facility and target date with a matching facility
Columns: facility_name, processing_date, daily_throughput, target_units, variance_units, and performance_status
Include dates with no completed processing as zero throughput
Sort by facility_name, then processing_date

facilities

processing_events

Column	Type	Description
event_idPK	INT	Unique processing event identifier
facility_id	INT	Facility where processing occurred
processed_at	TIMESTAMP	Event timestamp
processed_units	INT	Units handled by the event
status	VARCHAR(20)	Processing status

daily_targets

Column	Type	Description
target_idPK	INT	Unique daily target identifier
facility_id	INT	Facility assigned the target
target_date	DATE	Date covered by the target
target_units	INT	Expected processed units

Your question is SQL Throughput by Facility vs Target. 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.