SQL Proficiency Level

MediumSQL · PostgreSQL

Problem

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.

Output details

Treat only rows whose status is exactly Completed as completed work orders.
Include completion dates from DATE '2025-01-01' inclusively through dates before DATE '2026-01-01'.
Round average_duration_hours to two decimal places and report 0.00 when no qualifying work orders exist.

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

Tablestechnicianswork_orders

What is your SQL proficiency level?

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.

Output details

Treat only rows whose status is exactly Completed as completed work orders.
Include completion dates from DATE '2025-01-01' inclusively through dates before DATE '2026-01-01'.
Round average_duration_hours to two decimal places and report 0.00 when no qualifying work orders exist.