Employees Missing Building Number

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Employees Missing Building Number. Start with the requirements and the two tables on the right.

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

You need to log in / sign up to run or submit.

Find the employees who were in the company but did not have a building number. (Use JOIN).

Asked in the Virtual Onsite stage. SQL question requiring JOIN operations.

Requirements

Return each employee who exists in the company roster but has no building number recorded.
Use a JOIN-based solution, not a subquery.
Output the employee identifier and name.

employees

Column	Type	Description
employee_idPK	INT	Primary key for each employee
employee_name	VARCHAR(100)	Employee full name
status	VARCHAR(20)	Employment status

employee_buildings

Column	Type	Description
employee_id	INT	References employees.employee_id
building_number	VARCHAR(10)	Assigned building number, may be missing

Tablesemployeesemployee_buildings

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results