leetcode

0 SELECT D.name AS Department,

1 E.name AS Employee,

2 E.salary

3 FROM Employee E

4 LEFT JOIN Department D

5 ON E.departmentId = D.id

6 WHERE (D.id, E.salary) IN (

7 SELECT departmentId, MAX(salary) AS salary

8 FROM Employee

9 GROUP BY departmentId

10 )