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

[ji-0630]

문제 설명

[ji-0630]

다른 사람의 풀이

SELECT CART_ID
from (select CART_ID, name
      from CART_PRODUCTS
      where NAME = "Yogurt" or NAME = "Milk"
      group by cart_id, name) a
group by cart_id
having count(cart_id) >= 2
order by CART_ID

[ji-0630]

다시 풀기

SELECT CART_ID
from (select CART_ID, NAME
     from CART_PRODUCTS
     where NAME = 'MILK' or NAME = 'Yogurt'
     group by cart_id, name) c
group by cart_id
having count(cart_id) >= 2
order by CART_ID