SQL TTR by Team | Dataford Interview Questions

Given a table of incident logs, write a query to find the average time to resolve (TTR) for high-severity incidents by team.

Use only incidents with a recorded resolution timestamp and assigned team. Calculate TTR in hours, rounded to two decimal places.

Output

incident_logs

Column	Type	Description
incident_idPK	INT	Unique incident identifier
team	VARCHAR(100)	Team assigned to the incident
severity	VARCHAR(20)	Incident severity level
created_at	TIMESTAMPTZ	Timestamp when the incident was created
resolved_at	TIMESTAMPTZ	Timestamp when the incident was resolved

Your question is SQL TTR by Team. Start with the requirements and the one table 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.

Given a table of incident logs, write a query to find the average time to resolve (TTR) for high-severity incidents by team.

Use only incidents with a recorded resolution timestamp and assigned team. Calculate TTR in hours, rounded to two decimal places.

incident_logs

Column	Type	Description
incident_idPK	INT	Unique incident identifier
team	VARCHAR(100)	Team assigned to the incident
severity	VARCHAR(20)	Incident severity level
created_at	TIMESTAMPTZ	Timestamp when the incident was created
resolved_at	TIMESTAMPTZ	Timestamp when the incident was resolved

Your question is SQL TTR by Team. Start with the requirements and the one table 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.