Your question is Top Agents by Resolved Cases. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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.
status = 'Resolved'.agent_name is NULL.agent_name.agent_name ascending to break ties.| 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 |