기존학습자료/leetcode, hackerrank

Leetcode 181 - Employees Earning More Than Their Managers

gooreumsea 2023. 6. 24. 19:58

Employees Earning More Than Their Managers
https://leetcode.com/problems/Employees-Earning-More-Than-Their-Managers/

 

SELECT employee.name AS Employee
FROM employee
     INNER JOIN employee as Mannager ON employee.managerID = Mannager.id

WHERE employee.salary > Mannager.salary