SQL for Monthly SLA Attainment | Dataford Interview Questions

Write a SQL query to join operational performance data with client records and calculate monthly SLA attainment by team at Aon.

Treat NULL SLA statuses as not evaluated, excluding them from the attainment calculation. Include only performance records with a matching client record.

Output

One row per calendar month and team.
Columns: month, team, clients_served, evaluated_requests, sla_met_count, and sla_attainment_pct.
Include teams with at least one evaluated request. Sort by month ascending, then team ascending.

Schema

client_records

Column	Type	Description
client_idPK	INT	Unique client identifier
client_name	VARCHAR(150)	Client organization name
client_segment	VARCHAR(50)	Client service segment

operational_performance

Column	Type	Description
performance_idPK	INT	Unique operational performance record
client_id	INT	Client associated with the performance record
team	VARCHAR(100)	Operational team responsible for the request
performance_date	DATE	Date on which performance was measured
sla_met	BOOLEAN	Whether the request met its SLA

Your question is SQL for Monthly SLA Attainment. 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