Employee Manager Join
Medium
joins
The employees table has a manager_id column that references the
id of another employee. Write a query using a self-join to
return each employee's name alongside their manager's name.
Return columns employee_name and manager_name, ordered by
employee_name. Only include employees who have a manager.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...