Untitled

SELECT e.first_name AS employee first name, COALESCE(m.first_name, NO Manager') AS manager_first name FROM employees e LEFT JOIN employees m ON e.manager_id = m.employee_id;