select salaries.emp_no, a.manager_no, salaries.salary as emp_salary, a.manager_salary from dept_emp left join (select d.dept_no as dept_no, d.emp_no as manager_no, s.salary as manager_salary from salaries as s inner join dept_manager as d on d.emp_no = s.emp_no) a on dept_emp.dept_no = a.dept_no...