SELECT EMP_ID, EMP_NAME, SAL FROM EMP E WHERE SAL > 3000 AND EXISTS ( SELECT 1 FROM EMP M WHERE M.EMP_ID = E.MGR_ID );
SELECT EMP_ID, EMP_NAME, SAL FROM EMP WHERE SAL > 3000 AND MGR_ID IN ( SELECT EMP_ID FROM EMP );
SELECT EMP_ID, EMP_NAME, SAL FROM EMP E WHERE SAL > 3000 AND NOT EXISTS ( SELECT 1 FROM EMP M WHERE M.EMP_ID <> E.MGR_ID );
SELECT E1.EMP_ID, E1.EMP_NAME, E1.SAL FROM EMP E1, EMP E2 WHERE E1.MGR_ID = E2.EMP_ID AND E1.SAL > 3000;
나만의 풀이, 암기법을 나눠 보세요. 정답이 포함될 수 있어요.