Given table
employees(id, name, manager_id) with data:
1 | Alice | NULL
2 | Bob | 1
3 | Carol | 1
4 | Dave | 2
What will this query return?
SELECT e1.name AS employee, e2.name AS manager FROM employees e1 LEFT JOIN employees e2 ON e1.manager_id = e2.id;
A[{"employee": "Bob", "manager": null}, {"employee": "Dave", "manager": "Carol"}]
B[{"employee": "Alice", "manager": "Alice"}, {"employee": "Bob", "manager": "Bob"}]
C[{"employee": "Alice", "manager": "Bob"}, {"employee": "Carol", "manager": "Dave"}]
D[{"employee": "Alice", "manager": null}, {"employee": "Bob", "manager": "Alice"}, {"employee": "Carol", "manager": "Alice"}, {"employee": "Dave", "manager": "Bob"}]
