기존학습자료/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