133025.md

프로그래머스 133025

'과일로 만든 아이스크림 고르기'

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

SELECT H.FLAVOR
FROM FIRST_HALF H
JOIN ICECREAM_INFO I ON H.FLAVOR = I.FLAVOR
WHERE H.TOTAL_ORDER >3000
AND I.INGREDIENT_TYPE LIKE 'fruit_based'