Write a SQL query to analyze operational performance by region and month, joining orders, accounts, and support tickets to identify the top drivers of delayed resolution at Confluent. Treat resolved tickets taking more than 48 hours as delayed. Return only regions and months with at least one delayed ticket.
Output
- One row per region, month, and top driver, with ties retained through rank 3.
- Columns:
region, month, order_count, order_revenue, ticket_count, delayed_ticket_count, avg_resolution_hours, delayed_rate, prior_month_delayed_rate, driver, delayed_driver_count, driver_share_of_delayed, driver_rank.
- Sort by region, month, driver rank, and driver name.
