Sharing my simple solution
Select Department.Name, emp1.Name, emp1.Salary from \n    Employee emp1 join Department on emp1.DepartmentId = Department.Id\n    where emp1.Salary = (Select Ma
    Select Department.Name, emp1.Name, emp1.Salary from \n    Employee emp1 join Department on emp1.DepartmentId = Department.Id\n    where emp1.Salary = (Select Max(Salary) from Employee emp2 where emp2.DepartmentId = emp1.DepartmentId);
[]