Employees and Their Managers

Problem

Write a query that returns each employee's full name (aliased as employee_name) alongside their manager's full name (aliased as manager_name), using a self-join on the employees table. Employees who have no manager should still appear, with a NULL manager_name.

Try It

Hint

Solution