95% beats || MySQL solution
\n# Code\n\nselect Department,e.name as Employee,e.salary as Salary \nfrom employee e,\n(\n    select d.id department_id,d.name as Department,max(e.salary) as m
\n# Code\n```\nselect Department,e.name as Employee,e.salary as Salary \nfrom employee e,\n(\n    select d.id department_id,d.name as Department,max(e.salary) as max \n    from department d left join employee e \n    on  d.id=e.departmentId \n    group by d.id\n) as MaxSalaries \nwhere e.departmentId=department_id and e.salary = max;\n```\n\n```\nplease upvote, if you find it useful\n```
['MySQL']