Solution with Detail Explanation (Easy to Understand)
Please upvote Me ^ Thanks.\nIT IS SIMPLE \n\nfirst identify highest salary by \nSELECT departmentId,MAX(salary) FROM Employee GROUP BY departmentId\n\nThen JOIN
**Please upvote Me ^ Thanks.**\nIT IS SIMPLE \n\nfirst identify highest salary by \n`SELECT departmentId,MAX(salary) FROM Employee GROUP BY departmentId`\n\nThen JOIN both table by\n`SELECT Department.name AS Department ,Employee.name AS Employee, Employee.salary\nFROM Department  JOIN Employee  ON Employee.departmentId=Department.id `\n\nThen put Condition by\n`WHERE(departmentId, salary) IN\n(SELECT departmentId,MAX(salary) FROM Employee GROUP BY departmentId) ;`\n\n**Code**\n\n```\nSELECT Department.name AS Department ,Employee.name AS Employee, Employee.salary\nFROM Department  JOIN Employee  ON Employee.departmentId=Department.id \nWHERE(departmentId, salary) IN\n(SELECT departmentId,MAX(salary) FROM Employee GROUP BY departmentId) ;\n```
['MySQL']