Write a SQL query to analyze support ticket volume by day, ticket type, and resolution status, and identify the top drivers of backlog growth for Robinhood.
Use the provided support ticket and ticket type tables. Treat a ticket as created on its creation date and resolved on its resolution date. Include unmatched or missing ticket types as Unknown.
activity_date, ticket_type, resolution_status, daily_ticket_volume, tickets_created, tickets_resolved, backlog_growth, and driver_rank.| Column | Type | Description |
|---|---|---|
| ticket_type_idPK | INT | Unique ticket type identifier |
| ticket_type_name | VARCHAR(100) | Robinhood support ticket category |
| Column | Type | Description |
|---|---|---|
| ticket_idPK | INT | Unique support ticket identifier |
| ticket_type_id | INT | Ticket type reference |
| created_at | TIMESTAMP | Timestamp when the ticket was created |
| resolved_at | TIMESTAMP | Timestamp when the ticket was resolved |
| resolution_status | VARCHAR(30) | Current ticket resolution status |