牛客 SQL：查找所有员工的last_name和first_name以及对应的dept_name

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

代码：

SELECT e.last_name, e.first_name, dp.dept_name
FROM (employees AS e
LEFT JOIN dept_emp AS de
ON e.emp_no = de.emp_no)
LEFT JOIN departments AS dp
ON de.dept_no = dp.dept_no

SELECT e.last_name, e.first_name, NEWdp.dept_name
FROM employees AS e
LEFT JOIN (
    SELECT dp.dept_no, dp.dept_name, de.emp_no
    FROM departments AS dp
    LEFT JOIN dept_emp AS de
    ON dp.dept_no = de.dept_no
    
) AS NEWdp
ON e.emp_no = NEWdp.emp_no