How would you use SQL to identify the top 5 operational bottlenecks by average resolution time over the last quarter at Aon?
Use the operational bottleneck and ticket data to include only valid, resolved tickets opened during the last completed calendar quarter.
bottleneck_id, bottleneck_name, avg_resolution_hours, and resolved_ticket_countbottleneck_id ascending as the tie-breaker| Column | Type | Description |
|---|---|---|
| bottleneck_idPK | INT | Unique identifier for an operational bottleneck |
| bottleneck_name | VARCHAR(100) | Name of the operational bottleneck |
| Column | Type | Description |
|---|---|---|
| ticket_idPK | INT | Unique ticket identifier |
| bottleneck_id | INT | Referenced operational bottleneck |
| opened_at | TIMESTAMP | Timestamp when the ticket was opened |
| resolved_at | TIMESTAMP | Timestamp when the ticket was resolved |