SQL Proficiency Level | Dataford Interview Questions

What is your SQL proficiency level?

Demonstrate your level by querying the provided tables. Return one row for every technician, including technicians without qualifying completed work orders. Include only work orders completed during 2025.

Output

Columns: technician_name, completed_work_orders, average_duration_hours, proficiency_band
Assign High for at least 3 completed work orders, Standard for 1 or 2, and No completed work for 0.
Order by completed work orders descending, average duration descending, then technician name ascending.

Schema

technicians

Column	Type	Description
technician_idPK	INT	Unique technician identifier
technician_name	VARCHAR(100)	Technician's full name

work_orders

Column	Type	Description
work_order_idPK	INT	Unique work order identifier
technician_id	INT	Assigned technician identifier
status	VARCHAR(30)	Current work order status
completion_date	DATE	Date the work order was completed
duration_hours	NUMERIC(6,2)	Hours spent completing the work order

Your question is SQL Proficiency Level. Start with the requirements and the two 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