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
'기존학습자료 > leetcode, hackerrank' 카테고리의 다른 글
Leetcode 1179 - Reformat Department Table (0) | 2023.06.24 |
---|---|
Leetcode 183 - Customers Who Never Order (0) | 2023.06.24 |
Leetcode 197 - Rising Temperature (0) | 2023.06.24 |
Leetcode 595 - Big Countries (0) | 2023.06.24 |
Leetcode 620 - Not Boring Movies (0) | 2023.06.24 |