mediumSQLself-joinsSingle-choice MCQ

To build a hierarchy display with a self-join, this query lists employees and their managers. Which employees are MISSING from the result?

SELECT e.name AS emp, m.name AS mgr FROM employees e JOIN employees m ON e.manager_id = m.id;