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...