SQL for Operational Completion | Dataford Interview Questions

Write a SQL query to analyze operational performance by region and month, joining orders, technicians, and customer tables to calculate completion rate and average turnaround time.

Output

One row per region and order month.
Return region, order_month, total_orders, completed_orders, completion_rate, average_turnaround_days, and technicians_assigned.
Treat missing customer regions as Unknown, calculate turnaround only for completed orders with completion timestamps, and sort by region and month ascending.

Schema

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer associated with the order
technician_id	INT	Assigned technician identifier
order_date	TIMESTAMP	Timestamp when the order was created
completed_at	TIMESTAMP	Timestamp when the order was completed
status	VARCHAR(20)	Current order status

technicians

Column	Type	Description
technician_idPK	INT	Unique technician identifier
technician_name	VARCHAR(100)	Technician full name
specialty	VARCHAR(80)	Primary service specialty

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(120)	Customer name
region	VARCHAR(40)	Customer service region

Your question is SQL for Operational Completion. 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