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

▶MySQL

SELECT F.FLAVOR
FROM FIRST_HALF AS F INNER JOIN ICECREAM_INFO AS I
ON F.FLAVOR = I.FLAVOR
WHERE F.TOTAL_ORDER > 3000
AND I.INGREDIENT_TYPE = 'fruit_based'
ORDER BY TOTAL_ORDER DESC;

▶Oracle

SELECT F.FLAVOR
FROM FIRST_HALF F,ICECREAM_INFO I
WHERE F.FLAVOR = I.FLAVOR
AND F.TOTAL_ORDER > 3000
AND I.INGREDIENT_TYPE = 'fruit_based'
ORDER BY F.TOTAL_ORDER DESC;