SQLD CBT 기출문제 예상문제 951번

다음 문제를 풀어보세요.

다음 보기 중 아래 SQL과 실행 결과가 동일한 SQL로 가장 적절한 것을 고르시오.

[SQL]
SELECT C.CUST_ID, C.CUST_NAME
FROM   CUSTOMER C
WHERE  C.CUST_ID IN (SELECT O.CUST_ID 
                     FROM   ORDERS O 
                     WHERE  O.ORDER_DATE >= '20230101');

SELECT C.CUST_ID, C.CUST_NAME
FROM   CUSTOMER C
WHERE  EXISTS ( SELECT 1 
                FROM   ORDERS O 
                WHERE  O.ORDER_DATE >= '20230101');

SELECT C.CUST_ID, C.CUST_NAME
FROM   CUSTOMER C
WHERE  EXISTS ( SELECT 1 
                FROM   ORDERS O 
                WHERE  O.CUST_ID = C.CUST_ID 
                AND    O.ORDER_DATE >= '20230101' );

SELECT C.CUST_ID, C.CUST_NAME
FROM   CUSTOMER C, ORDERS O
WHERE  C.CUST_ID = O.CUST_ID
AND    O.ORDER_DATE >= '20230101';

SELECT C.CUST_ID, C.CUST_NAME
FROM   CUSTOMER C
WHERE  C.CUST_ID = ( SELECT O.CUST_ID 
                     FROM   ORDERS O 
                     WHERE  O.ORDER_DATE >= '20230101' );