Write a SQL query to analyze operational performance by region at Wise, joining transactions and support cases to calculate volume, resolution rate, and average handling time. Use all available records, including regions present in only one table. Treat unresolved cases as having no handling time.
Unknown for NULL regions.region, transaction_volume, support_case_volume, resolution_rate_pct, and avg_handling_hours.transaction_volume descending, then region ascending.| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique Wise transaction identifier |
| region | VARCHAR(50) | Operational region associated with the transaction |
| transaction_date | DATE | Date the transaction was initiated |
| Column | Type | Description |
|---|---|---|
| case_idPK | INT | Unique support case identifier |
| transaction_id | INT | Related transaction identifier when a case concerns a transaction |
| region | VARCHAR(50) | Operational region associated with the support case |
| status | VARCHAR(20) | Current case status |
| created_at | TIMESTAMP | Timestamp when the case was created |
| resolved_at | TIMESTAMP | Timestamp when the case was resolved |