题解 | 获取所有非manager员工当前的薪水情况

select de.dept_no, de.emp_no, s.salary
FROM employees e
LEFT JOIN dept_emp de
ON e.emp_no = de.emp_no
LEFT JOIN salaries s
ON e.emp_no = s.emp_no
LEFT JOIN dept_manager dm
ON e.emp_no = dm.emp_no
where dm.emp_no is NULL;