MySQL Clean Solution
Code\n\n# Write your MySQL query statement below\nSELECT d.name AS Department, e.name AS Employee, e.salary AS Salary\nFROM Department d, Employee e\nWHERE e.de
# Code\n```\n# Write your MySQL query statement below\nSELECT d.name AS Department, e.name AS Employee, e.salary AS Salary\nFROM Department d, Employee e\nWHERE e.departmentId = d.id AND (e.departmentId, salary) IN (\n    SELECT departmentId, MAX(salary)\n    FROM Employee \n    GROUP BY departmentId\n);\n```
['Database', 'MySQL']