SELECT t.dept_no, t.emp_no, t.salary AS maxSalary FROM ( SELECT t1.dept_no, t2.emp_no, t2.salary, row_number() over(partition by t1.dept_no order by t2.salary desc) as rk FROM dept_emp t1 LEFT JOIN salaries t2 ON t1.emp_no = t2.emp_no ) t WHERE rk = 1 ORDE...