Easy-Peasy Solution
Code\n\n# Write your MySQL query statement below\n\nselect d.name as department,e.name as employee ,e.salary from employee as e \njoin \ndepartment as d on e.de
# Code\n```\n# Write your MySQL query statement below\n\nselect d.name as department,e.name as employee ,e.salary from employee as e \njoin \ndepartment as d on e.departmentId=d.id \n    where (e.departmentId,e.salary) in (\n    select departmentId , max(salary) from employee\n    group by departmentId\n);\n```
['MySQL']