EasyOutput prediction
Self join with LEFT JOIN for hierarchy
Given this table (employees):
| id | name | manager_id |
|---|---|---|
| 1 | Alice | NULL |
| 2 | Bob | 1 |
| 3 | Carol | 1 |
What does this query return?
SELECT e.name AS employee, m.name AS manager FROM employees e LEFT JOIN employees m ON e.manager_id = m.id;
← → arrow keys to navigate
Sign in to save your progress.