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