Placement Velocity SQL Query | Dataford Interview Questions

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.

Output

One row per branch tied for the highest velocity.
Columns: branch_id, branch_name, placements_count, velocity_per_30_days, and velocity_rank.
Order by branch_name ascending.

Schema

branches

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

candidate_placements

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

Your question is Placement Velocity SQL Query. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem