select d.emp_no,
d1.emp_no manager_no,
s1.salary emp_salary,
s2.salary manager_salary
from dept_emp d
join dept_manager d1 on d1.dept_no = d.dept_no  员工表id连接部门经理表
join salaries s1 on s1.emp_no = d.emp_no 员工表连接薪资
join salaries s2 on s2.emp_no = d1.emp_no 经理表连接薪资
where 
s1.salary > s2.salary 员工薪资大于经理薪资