Your question is Placement Velocity SQL Query. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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.| 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 |