Microsoft's project office wants a list of approved projects that still have no one assigned.
List every project that has no rows in project_assignments.
Expected output
Example of the shape (made-up values):
| project_id | title | budget |
|---|---|---|
| 21 | Project Zephyr | 250000 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.