题解 | #查找所有员工的last_name和first_name以及对应的dept_name#
查找所有员工的last_name和first_name以及对应的dept_name
https://www.nowcoder.com/practice/5a7975fabe1146329cee4f670c27ad55
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