코딩테스트/프로그래머스

[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