leetcode 181. Employees Earning More Than Their Managers

 

 

1) SELF JOIN

 

1-1)

SELECT *

FROM Employee e1, Employee e2

WHERE e1.Id = e2.ManagerId

 

1-1) 결과

{"headers": ["Id", "Name", "Salary", "ManagerId", "Id", "Name", "Salary", "ManagerId"],

"values": [[3, "Sam", 60000, null, 1, "Joe", 70000, 3], [4, "Max", 90000, null, 2, "Henry", 80000, 4]]}

 

 

 

2) e1.Salary(매니저 급여) < e2.Salary(직원 급여)

SELECT *

FROM Employee e1, Employee e2

WHERE e1.Id = e2.ManagerId

   AND e1.Salary < e2.Salary

 

2-1) 결과

{"headers": ["Id", "Name", "Salary", "ManagerId", "Id", "Name", "Salary", "ManagerId"],

"values": [[3, "Sam", 60000, null, 1, "Joe", 70000, 3]]}

 

 

 

3) e1.Name 출력

SELECT e2.Name AS Employee

FROM Employee e1, Employee e2

WHERE e1.Id = e2.ManagerId

   AND e1.Salary < e2.Salary

 

3-1) 결과

{"headers": ["Employee"], "values": [["Joe"]]}

 

 

SUCCESS!!