SELECT e.first name, e.last name, e.department_id, COALESCE(d.department name, No Department') AS department_name FROM employees e LEFT JOIN departments d ON e.department_id = d.department_id;
