select t2.dept_no,t1.emp_no,t2.maxSalary as maxSalary from ( select de.dept_no,max(s.salary) maxSalary from dept_emp de left join salaries s on de.emp_no=s.emp_no group by de.dept_no ) t2 left join ( select de.emp_no,de.dept_no,s.salary from dept_emp de left join salari...