SQL for Operational Insights | Dataford Interview Questions

Can you provide an example of a SQL query you wrote to analyze operational data?

Using the provided tables, write a query that reports monthly Q1 2025 incident performance for support teams. Include operational incidents with valid tracked statuses and require at least two incidents for a team-month.

Output

One row per team and calendar month
Columns: team_name, month_start, total_incidents, resolved_incidents, avg_resolution_hours, and resolution_rate_pct
Sort by month, then team name alphabetically

Schema

support_teams

Column	Type	Description
team_idPK	INT	Unique support team identifier
team_name	VARCHAR(100)	Support team name

incidents

Column	Type	Description
incident_idPK	INT	Unique incident identifier
team_id	INT	Assigned support team identifier
created_at	TIMESTAMP	Incident creation timestamp
status	VARCHAR(30)	Current incident status
resolution_hours	DECIMAL(10,2)	Elapsed hours until resolution

Your question is SQL for Operational Insights. 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