SQL for Queue Performance | Dataford Interview Questions

Write a SQL query to analyze operational performance by queue, including volume, SLA attainment, and trend over time at SoFi.

Use the provided queue and case data for cases created during the first quarter of 2025. Return monthly results for queues with case activity.

Output

One row per queue and month, with queue_name, month_start, case_volume, and sla_attainment_pct.
SLA attainment is the percentage of cases resolved on or before their SLA due timestamp.
Sort by queue_name, then month_start ascending.

queues

Column	Type	Description
queue_idPK	INT	Unique queue identifier
queue_name	VARCHAR(100)	Display name of the operational queue

support_cases

Column	Type	Description
case_idPK	INT	Unique support case identifier
queue_id	INT	Queue assigned to the case
created_at	TIMESTAMP	Timestamp when the case was created
resolved_at	TIMESTAMP	Timestamp when the case was resolved
sla_due_at	TIMESTAMP	SLA deadline for the case

Your question is SQL for Queue Performance. 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.