[프로그래머스] 우유와 요거트가 담긴 장바구니 (MySQL)

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

 

프로그래머스

문제 링크입니다

 

---

 

 

 

풀이

 

 

1. 서브쿼리 조인

SELECT YG.CART_ID 
  FROM CART_PRODUCTS as MK
 INNER JOIN
       (SELECT *
          FROM CART_PRODUCTS
         WHERE NAME = 'Yogurt') as YG
ON MK.CART_ID = YG.CART_ID
WHERE MK.NAME = 'Milk'
ORDER BY MK.CART_ID

 

 

 

 

2. HAVING 사용

 

 

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