Show each employee's name and their manager's name (the CEO has none). Columns: employee, manager. Order by the employee's id.

Answer

SELECT e.name AS employee, m.name AS manager FROM employees e LEFT JOIN employees m ON e.manager_id = m.id ORDER BY e.id;