Find Employees With Managers | Dataford Interview Questions

NiCE uses employee hierarchy data to support administration and workforce workflows in NiCE CXone. Write a PostgreSQL query that lists every employee and, when available, the employee's direct manager.

Requirements

Return every employee, including employees who do not have a manager.
Display the employee's ID and name, plus the manager's ID and name.
Use a self-join with a LEFT JOIN, and sort the result alphabetically by employee name.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
manager_id	INTEGER	References employees.employee_id for the direct manager
job_title	VARCHAR(100)	Employee's job title
department	VARCHAR(100)	Organizational department
hire_date	DATE	Employee's hire date

Your question is Find Employees With Managers. 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 every employee, including employees who do not have a manager.
Display the employee's ID and name, plus the manager's ID and name.
Use a self-join with a LEFT JOIN, and sort the result alphabetically by employee name.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
manager_id	INTEGER	References employees.employee_id for the direct manager
job_title	VARCHAR(100)	Employee's job title
department	VARCHAR(100)	Organizational department
hire_date	DATE	Employee's hire date

Your question is Find Employees With Managers. 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.