Simple solution, easy to understand
SELECT dep.Name as Department, emp.Name as Employee, emp.Salary \n    from Department dep, Employee emp \n    where emp.DepartmentId=dep.Id \n    and emp.Salary
    SELECT dep.Name as Department, emp.Name as Employee, emp.Salary \n    from Department dep, Employee emp \n    where emp.DepartmentId=dep.Id \n    and emp.Salary=(Select max(Salary) from Employee e2 where e2.DepartmentId=dep.Id)
[]