simplest solution
\nselect d.name as Department ,e.name as Employee ,e.salary \nfrom Employee e, Department d \nwhere e.DepartmentId = d.id and (DepartmentId,Salary) in \n(select
```\nselect d.name as Department ,e.name as Employee ,e.salary \nfrom Employee e, Department d \nwhere e.DepartmentId = d.id and (DepartmentId,Salary) in \n(select DepartmentId,max(Salary) as max from Employee group by DepartmentId)\n```
['MySQL']