우유와 요거트가 담긴 장바구니

게시 2024/01/27

By tonyleekorea 1 분읽는 시간

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

문제 풀이

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

  
SELECT C.CART_ID
  FROM CART_PRODUCTS C
     , (
         SELECT CART_ID, COUNT(*) AS COUNT
         FROM CART_PRODUCTS
         WHERE NAME LIKE 'Yog%'
         GROUP BY CART_ID
         HAVING COUNT(*) = 1
     ) YO
     , (
         SELECT CART_ID, COUNT(*) AS COUNT
         FROM CART_PRODUCTS
         WHERE NAME LIKE 'Mil%'
         GROUP BY CART_ID
         HAVING COUNT(*) = 1
     ) MK
WHERE C.CART_ID = YO.CART_ID
  AND C.CART_ID = MK.CART_ID
 GROUP BY C.CART_ID
 ORDER BY C.CART_ID