SELECT 
    e.last_name 
    ,e.first_name 
    ,d.dept_no 
FROM employees e 
LEFT JOIN dept_emp d 
    ON e.emp_no  = d.emp_no
;

END