Top Agents by Resolved Cases | Dataford Interview Questions

A CXone support team wants a quick leaderboard of agents who closed the most cases. Write a SQL query to return the top 3 agents by number of resolved cases.

Requirements

Count only rows where status = 'Resolved'.
Exclude rows where agent_name is NULL.
Group results by agent_name.
Sort by resolved case count in descending order, then by agent_name ascending to break ties.
Return only the top 3 rows.

Schema

cxone_cases

Column	Type	Description
case_idPK	INT	Unique case identifier
agent_name	VARCHAR(100)	Name of the agent assigned to the case
status	VARCHAR(30)	Current case status
priority	VARCHAR(30)	Priority level of the case
created_date	DATE	Date the case was created

Your question is Top Agents by Resolved Cases. 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.

Problem

A CXone support team wants a quick leaderboard of agents who closed the most cases. Write a SQL query to return the top 3 agents by number of resolved cases.

Requirements

Count only rows where status = 'Resolved'.
Exclude rows where agent_name is NULL.
Group results by agent_name.
Sort by resolved case count in descending order, then by agent_name ascending to break ties.
Return only the top 3 rows.

Schema

cxone_cases

Column	Type	Description
case_idPK	INT	Unique case identifier
agent_name	VARCHAR(100)	Name of the agent assigned to the case
status	VARCHAR(30)	Current case status
priority	VARCHAR(30)	Priority level of the case
created_date	DATE	Date the case was created

Your question is Top Agents by Resolved Cases. 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.