Write a SQL query to analyze operational performance by team at Box, including joins across multiple tables and aggregations by month. Return monthly request volume, completed requests, completion rate, and average resolution time for each team with operational records. Rank teams within each month by completion rate, then request volume, and sort the final results chronologically.
Output
- One row per month and team
- Columns:
month, team_name, total_requests, completed_requests, completion_rate, avg_resolution_hours, and team_rank
- Include teams with operational records, order by month, rank, and team name
