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

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

프로그래머스

 

답 1

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

 

 

답 2

SELECT CART_ID, NAMES
FROM (
    SELECT CART_ID, GROUP_CONCAT(NAME) AS NAMES
    FROM CART_PRODUCTS
    GROUP BY CART_ID
) TMP
WHERE NAMES LIKE '%Milk%' 
    AND NAMES LIKE '%Yogurt%'

 

 

답 3

SELECT DISTINCT A.CART_ID
FROM CART_PRODUCTS A
INNER JOIN CART_PRODUCTS B
    ON A.CART_ID = B.CART_ID
WHERE A.NAME = 'Milk' AND B.NAME = 'Yogurt'
ORDER BY 1;

 

 

답 4

SELECT CART_ID
FROM CART_PRODUCTS
WHERE CART_ID IN ( SELECT CART_ID
                   FROM CART_PRODUCTS
                   WHERE NAME = 'Milk')
      	AND NAME = 'Yogurt'
ORDER BY CART_ID ASC;