select b.emp_no ,b.manager_no ,b.salary as emp_salary ,s.salary manager_salary from salaries s right join (select a.emp_no,s.salary,a.manager_no from salaries s right join ( select dp.emp_no,dp.dept_no,dr.emp_no manager_no from dept_emp dp left join dept_manager dr on dp.dept_n...