思路：和sql4差不多，将员工表作为主表即可

select
last_name
,first_name
,dept_no
from employees e
left join dept_emp d
on d.emp_no = e.emp_no