Inner Join - where - group by | 70.20% time
\n# Write your MySQL query statement below\nselect Department.name as Department, Employee.name as Employee, Employee.salary as salary\nfrom Employee\ninner joi
```\n# Write your MySQL query statement below\nselect Department.name as Department, Employee.name as Employee, Employee.salary as salary\nfrom Employee\ninner join Department on\nemployee.departmentId = department.id\nwhere \n(employee.departmentId, salary) IN (\n    select DepartmentId, max(salary)\n    from Employee\n    group by departmentId\n);\n\n```
[]