EASY MYSQL SOLUTION
\n\n# Code\n\nSELECT D.Name AS Department ,E.Name AS Employee ,E.Salary \nfrom \n\tEmployee E,\n\tDepartment D \nWHERE E.DepartmentId = D.id \n  AND (Department
\n\n# Code\n```\nSELECT D.Name AS Department ,E.Name AS Employee ,E.Salary \nfrom \n\tEmployee E,\n\tDepartment D \nWHERE E.DepartmentId = D.id \n  AND (DepartmentId,Salary) in \n  (SELECT DepartmentId,max(Salary) as max FROM Employee GROUP BY DepartmentId)\n```
['MySQL']