select T.dept_no, R.emp_no, T.ms as maxSalary from ( select d.dept_no, max(s.salary) as ms from dept_emp as d inner join salaries as s on d.emp_no = s.emp_no group by dept_no ) as T , ( select d.emp_no, d.dept_no, s.salary from dept_emp as d inner join salaries as s on d.emp_no = s.emp_no ) as R whe...