select a.dept_no, b.emp_no, a.maxSalary from ( select dept_emp.emp_no, dept_emp.dept_no, salaries.salary from dept_emp join salaries on dept_emp.emp_no = salaries.emp_no ) as b join ( select dept_no, max(salary) as maxSalary from dept_emp join salaries on dept_emp.em...