select t.dept_no,n.emp_no,t.maxSalary
from (select s.*,d.dept_no
      from salaries s 
      join dept_emp d 
      on s.emp_no = d.emp_no) n
join (select distinct d.dept_no,max(s.salary) maxSalary
    from dept_emp d 
    join salaries s
    on d.emp_no = s.emp_no
    group by d.dept_no) t
on t.maxSalary = n.salary and n.dept_no = t.dept_no
order by t.dept_no;