select de.emp_no,dm.emp_no,s1.salary,s2.salary
from dept_emp de
join dept_manager dm on de.dept_no=dm.dept_no
join salaries s1 on de.emp_no=s1.emp_no
join salaries s2 on dm.emp_no=s2.emp_no
where s1.salary>s2.salary;
select de.emp_no,dm.emp_no,s1.salary,s2.salary
from dept_emp de
join dept_manager dm on de.dept_no=dm.dept_no
join salaries s1 on de.emp_no=s1.emp_no
join salaries s2 on dm.emp_no=s2.emp_no
where s1.salary>s2.salary;