SQLD(SQL 개발자) 기출 · 단일행 함수

이 문제 풀어보기

1. 1.SELECT C.CUSTOMER_ID
   FROM CUSTOMERS C
   WHERE C.WEDDING_TYPE = 'Y'
   AND C.GENDER = 'F'
   AND TRUNC((SYSDATE - BIRTHDAY)/365) BETWEEN 40 AND 50
   AND EXISTS (SELECT 'X'
   FROM ORDERS O
   WHERE C.CUSTOMER_ID = O.CUSTOMER_ID);
2. 2.SELECT C.CUSTOMER_ID
   FROM CUSTOMERS C
   WHERE C.WEDDING_TYPE = 'Y'
   AND C.GENDER = 'F'
   AND TRUNC((SYSDATE - BIRTHDAY)/365) BETWEEN 40 AND 50
   AND C.CUSTOMER_ID IN (SELECT O.CUSTOMER_ID
   FROM ORDERS O);
3. 3.SELECT C.CUSTOMER_ID
   FROM CUSTOMERS C, (SELECT O.CUSTOMER_ID, COUNT(O.PROMOTION_ID) AS ORD_CNT
   FROM ORDERS O
   GROUP BY O.CUSTOMER_ID
   HAVING COUNT(O.PROMOTION_ID) >= 1) I
   WHERE C.CUSTOMER_ID = I.CUSTOMER_ID
   AND C.WEDDING_TYPE = 'Y'
   AND C.GENDER = 'F'
   AND TRUNC((SYSDATE - BIRTHDAY)/365) BETWEEN 40 AND 50;
4. 4.SELECT DISTINCT C.CUSTOMER_ID
   FROM CUSTOMERS C, ORDERS O
   WHERE C.CUSTOMER_ID = O.CUSTOMER_ID
   AND C.WEDDING_TYPE = 'Y'
   AND C.GENDER = 'F'
   AND TRUNC((SYSDATE - BIRTHDAY)/365) BETWEEN 40 AND 50;