select dep.dept_no, dep.emp_no, max(sal.salary)
from dept_emp dep join salaries sal
on dep.emp_no = sal.emp_no 
group by dep.dept_no