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

20240710 풀이

-- 코드를 입력하세요
SELECT CART_ID
FROM CART_PRODUCTS
WHERE NAME IN ('MILK', 'YOGURT')
GROUP BY CART_ID
HAVING COUNT(DISTINCT NAME) >= 2
ORDER BY CART_ID

---

20240906 풀이

-- 우유와 요거트를 동시에 구입한 장바구니
-- 장바구니 아이디 순서
SELECT *
FROM CART_PRODUCTS;

SELECT CART_ID
FROM CART_PRODUCTS
WHERE NAME IN ('Milk', 'Yogurt')
GROUP BY CART_ID
HAVING COUNT(DISTINCT NAME) >= 2
ORDER BY CART_ID;

 

https://school.programmers.co.kr/learn/courses/30/lessons/62284

프로그래머스