Employee and Manager Join Query | Dataford Interview Questions

Beaconfiresolution needs an employee directory showing each employee and the person they report to. The reporting hierarchy is stored in a single employee table.

Write a PostgreSQL query to return every employee's name and manager's name.

Requirements

Use a self-join on the employee table to match each employee with their manager.
Include employees who do not have a manager.
Display No manager when an employee's manager_id is NULL.
Sort the results by employee ID in ascending order.

Schema

employee

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
manager_id	INTEGER	References employee_id for the employee's manager

Your question is Employee and Manager Join Query. 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