Interview Guides
You are given operational activity and cost data from a brokerage operations workflow. Write a PostgreSQL query to report monthly performance by team for Gallagher teams, combining activity records with monthly team costs. Your result should show each team and month with total completed volume, average turnaround time in hours, and cost per unit. Teams with activity but no matching monthly cost should still appear, and cost per unit should safely handle missing or zero volume.