select dept_emp.emp_no, s1.emp_no as manager_no, salaries.salary, s1.salary as manager_salary from salaries join dept_emp on dept_emp.emp_no = salaries.emp_no join ( select dept_manager.dept_no, dept_emp.emp_no, salaries.salary from dept_emp left join salaries on salaries.emp_no = dept_emp.emp_no ri...