Recruiters Who Never Staffed Helix
Problem
A staffing agency tracks recruiters, client firms, and the placements recruiters make.
```
Recruiter
+-----------------+---------+
| Column | Type |
+-----------------+---------+
| recruiter_id | int |
| recruiter_name | varchar |
| base_pay | int |
+-----------------+---------+
ClientFirm
+-----------+---------+
| Column | Type |
+-----------+---------+
| firm_id | int |
| firm_name | varchar |
+-----------+---------+
Placement
+--------------+------+
| Column | Type |
+--------------+------+
| placement_id | int |
| firm_id | int |
| recruiter_id | int |
+--------------+------+
```
Return the `recruiter_name` of every recruiter who has **never** made a placement at the firm named `Helix`. Return the result in any order.
Tables
Example rows — the live problem includes the full dataset.
| recruiter_id | recruiter_name | base_pay |
|---|---|---|
| 1 | Dana | 90000 |
| 2 | Omar | 72000 |
| 3 | Priya | 81000 |
| firm_id | firm_name |
|---|---|
| 1 | Helix |
| 2 | Vertex |
| 3 | Quanta |
| placement_id | firm_id | recruiter_id |
|---|---|---|
| 1 | 3 | 4 |
| 2 | 4 | 5 |
| 3 | 1 | 1 |
Expected output
Your answer should return 3 rows with the columns recruiter_name.
Starter code (SQL)
SELECT *
FROM Recruiter;Solve this SQL question free
Write SQL and run it instantly in your browser — even on your phone. No signup needed to try.
Solution & explanation
Create a free account to unlock the optimal solution, a step-by-step explanation, and the hidden test cases that grade your answer.
Sign up free to unlock