select c.dept_no,d.emp_no,c.maxSalary from(select p.dept_no,max(p.salary) as maxSalaryfrom (select dept_no,a.emp_no,salary from dept_emp a join salaries b on a.emp_no=b.emp_no order by salary desc)pgroup by dept_no)cleft join(select dept_no,a.emp_no,salaryfrom dept_emp a join salaries bo...