select e_emp_no, m_emp_no,e_salary,m_salary from
(select *from
(select a.emp_no as e_emp_no,b.emp_no as m_emp_no from dept_emp a
join dept_manager b
on a.dept_no=b.dept_no
where a.emp_no not in (select emp_no from dept_manager))e
left join
(select c.emp_no,salary as e_salary from salaries c
left join
(select emp_no,max(to_date) as b_date from salaries
group by emp_no)d
on c.emp_no=d.emp_no
where c.to_date=b_date)f
on e.e_emp_no=f.emp_no)j
left join
(select g.emp_no,salary as m_salary from salaries g
left join
(select emp_no,max(to_date) as b_date from salaries
group by emp_no)h
on g.emp_no=h.emp_no
where g.to_date=b_date)i
on j.m_emp_no=i.emp_no
where e_salary>m_salary
(select *from
(select a.emp_no as e_emp_no,b.emp_no as m_emp_no from dept_emp a
join dept_manager b
on a.dept_no=b.dept_no
where a.emp_no not in (select emp_no from dept_manager))e
left join
(select c.emp_no,salary as e_salary from salaries c
left join
(select emp_no,max(to_date) as b_date from salaries
group by emp_no)d
on c.emp_no=d.emp_no
where c.to_date=b_date)f
on e.e_emp_no=f.emp_no)j
left join
(select g.emp_no,salary as m_salary from salaries g
left join
(select emp_no,max(to_date) as b_date from salaries
group by emp_no)h
on g.emp_no=h.emp_no
where g.to_date=b_date)i
on j.m_emp_no=i.emp_no
where e_salary>m_salary