[Summer/winter Coding(2019)] - 우유와 요거트가 담긴 장바구니

[문제설명]

[출력예시]

[출력 결과]

-- MySQL
--self join

SELECT DISTINCT a.CART_ID  -- 중복제거
FROM (
      SELECT CART_ID
      FROM CART_PRODUCTS
      WHERE NAME = "Milk"
    ) a
    JOIN
    (
    	SELECT CART_ID
        FROM CART_PRODUCTS
        WHERE NAME = "Yogurt"
     ) b
ON a.CART_ID = b.CART_ID
ORDER BY a.CART_ID asc