Join Employees and Departments | Dataford Interview Questions

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

Your question is Join Employees and Departments. Start with the requirements and the one table in the Question tab.

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

Problem

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

Your question is Join Employees and Departments. Start with the requirements and the one table in the Question tab.

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