SQL for Monthly SLA Attainment | Dataford Interview Questions

Write a SQL query to calculate monthly SLA attainment by client, including joins between operational and client tables and a breakdown by month at WNS. Treat records with sla_met = TRUE as attained and exclude records where sla_met is NULL from the percentage calculation.

Output

One row per matched client and calendar month with at least one non-NULL SLA result.
Columns: client_name, month, and sla_attainment_pct.
Format month as YYYY-MM, calculate attainment as a percentage rounded to two decimal places, and order by client name and month ascending.

Schema

operational_records

Column	Type	Description
operation_idPK	INT	Unique operational record identifier
client_id	INT	Client associated with the operational record
operation_date	DATE	Date when the operational activity occurred
sla_met	BOOLEAN	Whether the operational record met its SLA

clients

Column	Type	Description
client_idPK	INT	Unique client identifier
client_name	VARCHAR(100)	Client display name

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