Using inner join, easy to understand
\nSELECT Department.Name AS Department, Employee.Name AS Employee, Employee.Salary AS Salary\nFROM Employee INNER JOIN Department\nON Employee.DepartmentId =Dep
```\nSELECT Department.Name AS Department, Employee.Name AS Employee, Employee.Salary AS Salary\nFROM Employee INNER JOIN Department\nON Employee.DepartmentId =Department.Id\nWHERE Employee.Salary=\n    (\n        SELECT MAX(Salary) FROM Employee  \n        WHERE Employee.DepartmentId=Department.Id\n    );\n\t```
['MySQL']