Give me a list of buildings where there are no employees in them (employee and building tables). Asked in the phone interview, SQL stage.
Write a SQL query using the provided tables.
building_id, building_name, and citybuilding_id in ascending order| Column | Type | Description |
|---|---|---|
| building_idPK | INT | Unique identifier for the building |
| building_name | VARCHAR(100) | Name of the building |
| city | VARCHAR(100) | City where the building is located |
| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique identifier for the employee |
| employee_name | VARCHAR(100) | Employee's name |
| building_id | INT | Building assigned to the employee |