728x90
https://leetcode.com/problems/employees-whose-manager-left-the-company/
SELECT employee_id FROM Employees
WHERE
salary < 30000
AND
manager_id NOT IN (SELECT employee_id FROM Employees)
ORDER BY employee_id ASC;728x90
'IT > 코딩테스트' 카테고리의 다른 글
| [Leetcode] 2859. Sum of Values at Indices With K Set Bits (0) | 2023.09.17 |
|---|---|
| [Leetcode] 1141. User Activity for the Past 30 Days I (0) | 2023.09.06 |
| [Leetcode] 1075. Project Employees I (0) | 2023.09.04 |
| [Leetcode] 2843. Count Symmetric Integers (0) | 2023.09.03 |
| [Leetcode] 1051. Height Checker (0) | 2023.09.02 |