[LeetCode] Employees Earning More Than Their Managers

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

같은 테이블을 inner join 시켜야하는 재미난 문제

 

(문제 출처 - https://leetcode.com/problemset/database/)