Join Employees and Departments

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Join Employees and Departments. Start with the requirements and the one table 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

Hyundai Autoever America maintains an employee directory for internal software and operations reporting. Write a PostgreSQL query that returns each employee together with the department name stored in the directory.

Requirements

Return the employee ID, employee name, job title, and department name.
Include employees whose department name is currently unknown, and sort the results by employee ID in ascending order.

Schema

employee_directory

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
job_title	VARCHAR(100)	Current job title
department_name	VARCHAR(100)	Assigned department name, when available

Tablesemployee_directory

Your solutionPostgreSQL

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

Run a query to see results