Employee and Department Join With NULLs

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Employee and Department Join With NULLs. 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.

Problem

Yardi Voyager exports employee records separately from department reference data. Write a PostgreSQL query that reports each employee and the department name associated with their dept_id.

Requirements

Return every employee, including employees whose dept_id is NULL.
Match employees to departments using dept_id.
Return emp_id, name, and dept_name.
Sort the result by emp_id in ascending order. If no department matches, dept_name must remain NULL.

Schema

employees

Column	Type	Description
emp_idPK	INT	Unique employee identifier
name	VARCHAR(100)	Employee full name
dept_id	INT	Optional reference to departments.dept_id

departments

Column	Type	Description
dept_idPK	INT	Unique department identifier
dept_name	VARCHAR(100)	Department display name

Tablesemployeesdepartments

Your solutionPostgreSQL

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

Run a query to see results