simple MYSQL query
\nSELECT \n    d.Name AS Department, e.Name AS Employee, e.Salary AS Salary\nFROM \n    Employee AS e, Department AS d\nWHERE \n    e.DepartmentID = d.Id\n    A
```\nSELECT \n    d.Name AS Department, e.Name AS Employee, e.Salary AS Salary\nFROM \n    Employee AS e, Department AS d\nWHERE \n    e.DepartmentID = d.Id\n    AND\n    e.Salary = (SELECT \n                    MAX(Salary) \n               FROM \n                    Employee\n               WHERE\n                    DepartmentId = d.Id)\n```
[]