[Programmers Summer/Winter Coding(2019)] 우유와 요거트가 담긴 장바구니

문제 link
https://programmers.co.kr/learn/courses/30/lessons/62284

Code link
https://github.com/JamesJung01/Programmers_sql_kit/blob/main/Milk%26Yogurt.sql

CASE 1

SELECT DISTINCT A.CART_ID
FROM (SELECT CART_ID
      FROM CART_PRODUCTS
      WHERE NAME LIKE 'Milk') A
JOIN (SELECT CART_ID
      FROM CART_PRODUCTS
      WHERE NAME LIKE 'Yogurt') B
ON A.CART_ID = B.CART_ID
ORDER BY CART_ID;

CASE 2

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