A recruitment company wants to compare branch performance for September 2026. Write a SQL query to calculate each branch's total candidates placed and placement transactions during that month, include only branches that placed more than 100 candidates, and assign their placement rank.
Output
- One row per qualifying branch, with columns
branch_name, candidates_placed, total_placements, and placement_rank.
- Include only branches with more than 100 candidates placed during September 2026. NULL candidate values are ignored by the candidate total.
- Rank branches from highest to lowest total placements. Branches tied on total placements share a rank.
- Order by total placements descending, then branch name ascending.
