SQLD(SQL 개발자) 기출 · JOIN

이 문제 풀어보기

1. 1.SELECT C.NAME, P.PROD_NAME
   FROM CUSTOMER C
   LEFT JOIN ORDER_INFO O ON C.CUST_ID = O.CUST_ID
   RIGHT JOIN PRODUCT P ON O.PROD_ID = P.PROD_ID;
2. 2.SELECT NAME, PROD_NAME
   FROM CUSTOMER
   WHERE CUST_ID IN (
   SELECT CUST_ID
   FROM ORDER_INFO
   WHERE PROD_ID IN (
   SELECT PROD_ID FROM PRODUCT WHERE PROD_NAME = 'Book'
   ));
3. 3.SELECT C.NAME, P.PROD_NAME
   FROM CUSTOMER C
   JOIN ORDER_INFO O ON C.CUST_ID = O.CUST_ID
   JOIN PRODUCT P ON O.PROD_ID = P.PROD_ID;
4. 4.SELECT C.NAME, P.PROD_NAME
   FROM PRODUCT P
   JOIN ORDER_INFO O ON P.PROD_ID = O.PROD_ID
   JOIN CUSTOMER C ON C.CUST_ID = O.CUST_ID
   WHERE P.PROD_NAME = 'Pen';