[LeetCode] 181. Employees Earning More Than Their Managers

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT e1.name AS Employee
FROM Employee AS e1
    INNER JOIN Employee AS e2 ON e1.managerID = e2.id
WHERE e1.salary > e2.salary