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

select
    a.last_name,
    a.first_name,
    b.dept_name
from
    employees a
   left join dept_emp c using (emp_no)
   left join departments b using (dept_no)