LeetCode[MySQL] : Rising Temperature

Department Highest Salary

Q

SELECT D.name AS 'Department', E.name AS 'Employee', Salary
FROM Employee E JOIN Department D ON E.DepartmentId = D.Id
WHERE (E.DepartmentId , Salary) IN (SELECT DepartmentId, MAX(Salary) 
                                    FROM Employee E
                                    GROUP BY DepartmentId);