184. leetcode solution in MYSQL

SELECT
    Department.name AS 'Department',
    Employee.name AS 'Employee',
    Employee.Salary
FROM
    Employee
JOIN -- default is inner join
    Department
ON Employee.DepartmentId = Department.Id
WHERE
    (Employee.DepartmentId , Employee.Salary) IN -- so that if tie, both will appear in result
    (
        SELECT
            DepartmentId, MAX(Salary)
        FROM
            Employee
        GROUP BY DepartmentId
    )
;