programmers_과일로_만든_아이스크림_고르기.sql

SELECT FLAVOR
FROM FIRST_HALF
WHERE TOTAL_ORDER > 3000
    AND FLAVOR IN (SELECT FLAVOR
                    FROM ICECREAM_INFO
                    WHERE INGREDIENT_TYPE = 'fruit_based')