[SELECT/LEVEL1] 과일로 만든 아이스크림 고르기 (MySQL/Oracle)

MySQL/Oracle

SELECT A.FLAVOR
FROM FIRST_HALF A, ICECREAM_INFO B
WHERE A.FLAVOR = B.FLAVOR
  AND A.TOTAL_ORDER > 3000
  AND B.INGREDIENT_TYPE = 'fruit_based'