[LeetCode/SQL] 181. Employees Earning More Than Their Managers

[LeetCode/SQL]

---

📌 181. Employees Earning More Than Their Managers

문제

풀이

- Manager보다 급여가 더 높은 직원의 이름 출력하기

=>Employee 테이블의 id를 이용하여,manager 급여 추출 가능
=>셀프 조인을 이용해서 확인해보기 

방법

SELECT e1.name AS Employee
FROM employee AS e1
LEFT JOIN employee AS e2
ON e1.managerId=e2.id
WHERE e1.salary>e2.salary