[lv.1] 과일로 만든 아이스크림 고르기

SELECT A.FLAVOR
FROM FIRST_HALF A LEFT JOIN ICECREAM_INFO B ON A.FLAVOR=B.FLAVOR 
WHERE TOTAL_ORDER >=3000 AND INGREDIENT_TYPE='fruit_based'
ORDER BY TOTAL_ORDER DESC;