[Oracle] 우유와 요거트가 담긴 장바구니

https://school.programmers.co.kr/learn/courses/30/lessons/62284

프로그래머스

정답

1. INTERSECT (교집합)

SELECT cart_id
FROM CART_PRODUCTS
WHERE NAME = 'Yogurt'
INTERSECT
SELECT cart_id
FROM CART_PRODUCTS 
WHERE NAME ='Milk'
ORDER BY cart_id

2. 서브쿼리

SELECT DISTINCT CART_ID
FROM CART_PRODUCTS 
WHERE CART_ID IN (
        SELECT CART_ID
        FROM CART_PRODUCTS
        WHERE NAME='Milk'
    )
    AND NAME = 'Yogurt'
ORDER BY CART_ID

---

서브 쿼리 풀이

SELECT CART_ID
FROM CART_PRODUCTS
WHERE NAME='Milk'

SELECT CART_ID
FROM CART_PRODUCTS 
WHERE NAME = 'Yogurt'

SELECT DISTINCT CART_ID
FROM CART_PRODUCTS 
WHERE NAME = 'Yogurt' 
   AND CART_ID IN (
        SELECT CART_ID
        FROM CART_PRODUCTS
        WHERE NAME='Milk'
    )   
ORDER BY CART_ID