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

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

프로그래머스

WITH TEMP AS (
SELECT
        CART_ID, GROUP_CONCAT(NAME) AS P_NAME
FROM
        CART_PRODUCTS
GROUP BY
        CART_ID
ORDER BY
        CART_ID
)
SELECT 
    CART_ID
FROM
    TEMP
WHERE 
    P_NAME LIKE '%Milk%' AND P_NAME LIKE '%Yogurt%'
ORDER BY
    CART_ID

어려운 문제가 아니다. GROUP_CONCAT만 잘 쓰면 문제를 쉽게 풀 수 있다.