[SQL][Leetcode] 181. Employees Earning More Than Their Managers

https://leetcode.com/problems/employees-earning-more-than-their-managers/

Employees Earning More Than Their Managers - LeetCode

Problem                                                                                                                      

Analysis                                                                                                                     

1. Id와 ManagerId가 같은걸 JOIN 한다.

2.Salary가 managers 보다 사람을 찾는다.

 

Solution                                                                                                                    

SELECT E.Name AS Employee
FROM Employee AS E
JOIN Employee AS A ON E.ManagerId = A.Id 
WHERE E.Salary > A.Salary