프로그래머스 Lv.4| MySQL - 우유와 요거트가 담긴 바구니

pg

풀이(

SELECT C.CART_ID
FROM CART_PRODUCTS C JOIN (SELECT CART_ID, NAME
                    FROM CART_PRODUCTS
                    WHERE NAME IN ('Milk')) M
ON C.CART_ID = M.CART_ID
WHERE C.NAME IN ('Yogurt')
GROUP BY CART_ID
ORDER BY CART_ID

comments powered by Disqus