[프로그래머스] 우유와 요거트가 담긴 장바구니

---

-- GROUP BY 방법
SELECT CART_ID
    FROM (
        SELECT DISTINCT CART_ID, NAME
            FROM CART_PRODUCTS
            WHERE NAME IN ('Milk', 'Yogurt')
        ) T1
    GROUP BY CART_ID
    HAVING COUNT(1) >= 2
    ORDER BY CART_ID
    
-- SUBQUERY 방법
SELECT DISTINCT CART_ID
    FROM CART_PRODUCTS
    WHERE NAME IN ('Milk')
        AND CART_ID IN (SELECT CART_ID 
                            FROM CART_PRODUCTS
                            WHERE NAME IN ('Yogurt'))