MySQL using inner join
\nselect d.Name as Department,\ne.Name as Employee,\ne.Salary\nfrom Employee e inner join Department d\non e.DepartmentId = d.Id\nwhere e.Salary = (select max(s
```\nselect d.Name as Department,\ne.Name as Employee,\ne.Salary\nfrom Employee e inner join Department d\non e.DepartmentId = d.Id\nwhere e.Salary = (select max(salary) from Employee where departmentId = d.Id);\n```
[]