题解 | #查找所有员工名字以及对应的dept_name#

select
    e.last_name,
    e.first_name,
    d.dept_name
from
    employees as e
    left join dept_emp as de on e.emp_no = de.emp_no
    left join departments as d on d.dept_no = de.dept_no;