1.先获取所有非领导员工的工资
2.在筛选普通员工大于领导员工的工资的数据
3.再使用子查询对应查出该员工领导的工资

select
a.emp_no,
(select c.emp_no from dept_manager c where a.dept_no =c.dept_no ),
d.salary,
(select s1.salary from salaries s1 inner join dept_manager m1 on s1.emp_no = m1.emp_no where a.dept_no= m1.dept_no)
from dept_emp a
inner join salaries d on a.emp_no = d.emp_no
where
a.emp_no not IN(select emp_no from dept_manager)
and
a.dept_no IN (select dept_no from dept_manager)
and
d.salary > (select salary from dept_manager m inner join salaries s on m.emp_no = s.emp_no where a.dept_no = m.dept_no)