코딩테스트/프로그래머스
[SQL] 우유와 요거트가 담긴 장바구니
Initsave
2024. 2. 15. 07:25
-- 코드를 입력하세요
SELECT CART_ID
FROM CART_PRODUCTS
WHERE NAME IN ('Milk','Yogurt')
GROUP BY CART_ID
HAVING COUNT(DISTINCT NAME) = 2
ORDER BY CART_ID