Empty Neighborhoods
We’re given two tables, a users table with demographic information and the neighborhood they live in and a neighborhoods table.
Write a query that returns all neighborhoods that have 0 users.
Example:
Input:
users table
| Columns | Type |
|---|---|
id |
INTEGER |
name |
VARCHAR |
neighborhood_id |
INTEGER |
created_at |
DATETIME |
neighborhoods table
| Columns | Type |
|---|---|
id |
INTEGER |
name |
VARCHAR |
city_id |
INTEGER |
Output:
| Columns | Type |
|---|---|
name |
VARCHAR |
.....
Loading editor