Write a SQL query to identify branches with the highest candidate placement velocity over the last quarter.
Use the supplied branch and placement data. Treat velocity as completed placements per 30 calendar days during the last completed calendar quarter, and include ties for the highest velocity.
branch_id, branch_name, placements_count, velocity_per_30_days, and velocity_rank.branch_name ascending.DATE '2026-07-15' as today's date.placement_status equals placed, using placement_date for quarter membership.velocity_per_30_days to two decimal places.placements_count as 0 and their velocity as 0.00.| Column | Type | Description |
|---|---|---|
| branch_idPK | INT | Unique branch identifier |
| branch_name | VARCHAR(100) | Manpower Belgium branch name |
| city | VARCHAR(100) | City where the branch operates |
| Column | Type | Description |
|---|---|---|
| placement_idPK | INT | Unique placement identifier |
| branch_id | INT | Branch responsible for the placement |
| placement_date | DATE | Date the candidate placement was recorded |
| placement_status | VARCHAR(30) | Current placement status |