Write a SQL query to track monthly operational volumes, exception rates, and approval turnaround time by branch and product line at East West Bank.
Use the provided operational case, branch, and product line data. Treat the submitted timestamp as the reporting month, calculate exception rate as a percentage of total cases, and calculate average approval turnaround in hours for cases with an approval timestamp.
Output
- One row per month, branch, and product line with operational activity.
- Columns:
month, branch_name, product_line_name, operational_volume, exception_rate_pct, and avg_approval_hours.
- Sort by month, branch name, and product line name ascending.
