[프로그래머스 / SQL] 과일로 만든 아이스크림 고르기

-Code

SELECT
    HALF.FLAVOR
FROM
    FIRST_HALF AS HALF
    JOIN
    ICECREAM_INFO AS INFO
    ON
    HALF.FLAVOR = INFO.FLAVOR
WHERE
    INGREDIENT_TYPE = 'fruit_based'
    AND
    TOTAL_ORDER > 3000;