Interview Guides
You are given the task of analyzing branch performance for a retail banking network. Write a PostgreSQL query that joins and_huntington_transactions, and_huntington_employees, and and_huntington_branches to calculate total monthly revenue per branch and identify the top-performing branch or branches for each month. Treat revenue as the sum of positive transaction amounts only, and ignore rows where the transaction is not tied to a valid employee-branch relationship.
