Write a SQL query to analyze support operations performance by team and week, including ticket volume, resolution rate, and average handle time for Harvey.
Use the provided teams and support_tickets tables. Treat Monday as the start of each week, calculate resolution rate as resolved tickets divided by all tickets, and ignore NULL handle times when averaging.
team_name, week_start, ticket_volume, resolution_rate_pct, avg_handle_time_minutesteam_name, then week_start| Column | Type | Description |
|---|---|---|
| team_idPK | INT | Unique support team identifier |
| team_name | VARCHAR(100) | Harvey support team name |
| region | VARCHAR(50) | Operating region for the team |
| Column | Type | Description |
|---|---|---|
| ticket_idPK | INT | Unique support ticket identifier |
| team_id | INT | Assigned support team identifier |
| created_at | TIMESTAMP | Timestamp when the ticket was created |
| status | VARCHAR(30) | Current ticket status |
| handle_minutes | NUMERIC(8,2) | Minutes spent handling the ticket |