LeetCode / 1978. Employees Whose Manager Left the Company / MySQL(Easy) / Subquery

📚문제

출처 : LeetCode (https://leetcode.com/problems/employees-whose-manager-left-the-company/)

📝풀이

# Write your MySQL query statement below
SELECT employee_id
FROM Employees
WHERE manager_id NOT IN (SELECT employee_id
                         FROM Employees
                         )
 AND salary < 30000
ORDER BY employee_id

풀이는 간단한데

의외로 시간 오래걸렸다...

 

엄청 복잡하게만 생각해서 그런 것 같다

한 번 풀이 방향이 보이지 않으면

꽤 힘들어진다 🫠