SELF JOIN
Intermediate
The employees table has a manager_id column that points at another row in the same table (the manager's id). The top person has manager_id NULL.
Write a query returning each employee's name as employee and their manager's name as manager. Employees without a manager (the top of the chart) are not listed.
Constraints
- Columns, in order:
employee,manager - Join
employeesto itself - Employees with no manager are excluded
Hints
Hint 1
Use the table twice with two different aliases, e.g. employees e and employees m.
Hint 2
Match e.manager_id to m.id.
Keywords
db
SQL
Run your code to see results
No results yet
Run your code to check it against the examples, or submit to run every test.