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

 

 

-- 코드를 입력하세요
SELECT ICECREAM_INFO.FLAVOR
from FIRST_HALF inner join ICECREAM_INFO
on FIRST_HALF.FLAVOR = ICECREAM_INFO.FLAVOR
where TOTAL_ORDER >= 3000 and INGREDIENT_TYPE = 'fruit_based'
order by TOTAL_ORDER desc