SQL Solution
Code\n\nselect Department.name as department, Employee.name as employee, salary\nfrom Employee join Department on Employee.DepartmentId = Department.Id\nwhere (
# Code\n```\nselect Department.name as department, Employee.name as employee, salary\nfrom Employee join Department on Employee.DepartmentId = Department.Id\nwhere (Employee.DepartmentId, Salary) in (\n    select DepartmentId, max(Salary) from Employee \n    group by DepartmentId\n);\n```
['MySQL', 'PostgreSQL']