获取员工其当前的薪水比其manager当前薪水还高的相关信息

select t2.emp_no emp_no,t1.emp_no manager_no,t2.salary emp_salary,t1.salary manager_salary
from 
#部门经理的薪水
(select dm.dept_no dept_no,dm.emp_no emp_no,s.salary salary
from dept_manager dm join salaries s on dm.emp_no=s.emp_no)t1
,
#非部门经理的薪水
(select de.dept_no dept_no,de.emp_no emp_no,s.salary salary
from dept_emp de join salaries s on de.emp_no=s.emp_no
where de.emp_no not in 
(select  dm.emp_no from dept_manager dm))t2

where t1.dept_no=t2.dept_no and t1.salary<t2.salary