题解 | #查找所有员工的last_name和first_name以及对应的dept_name#

select
    last_name,
    first_name,
    dept_name
from
    dept_emp
    left join departments on dept_emp.dept_no = departments.dept_no
    right join employees on dept_emp.emp_no = employees.emp_no