select
employee.emp_no
,manager.emp_no manager_no
,employee.salary emp_salary
,manager.salary manager_salary
from
(
select # 先获取manager薪水等信息
dept_no
,d_manager.emp_no
,salary
from dept_manager d_manager
join salaries s
on d_manager.emp_no = s.emp_no
) manager
join
(
select # 获取非manager的员工薪水等信息
dept_no
,d_emp.emp_no
,salary
from dept_emp d_emp
join salaries s
on d_emp.emp_no = s.emp_no
where d_emp.emp_no not in (select emp_no from dept_manager)
) employee
on manager.dept_no = employee.dept_no
where employee.salary > manager.salary