Write a query to find the top three Asurion customer support agents with the highest resolution rates per region. Resolution rate is resolved cases divided by all assigned cases. Exclude agents without a region or assigned cases. Return exactly the top three agents per region, breaking ties by resolved case count and then agent ID.
region, agent_id, agent_name, resolved_cases, total_cases, resolution_rate, and agent_rankregion, then agent_rank| Column | Type | Description |
|---|---|---|
| agent_idPK | INT | Unique support agent identifier |
| agent_name | VARCHAR(100) | Support agent name |
| region | VARCHAR(50) | Agent's assigned operating region |
| Column | Type | Description |
|---|---|---|
| case_idPK | INT | Unique customer support case identifier |
| agent_id | INT | Assigned support agent identifier |
| status | VARCHAR(30) | Current case status |