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

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

 

MYSQL

SELECT FH.FLAVOR
FROM FIRST_HALF FH JOIN ICECREAM_INFO II
USING (FLAVOR)
WHERE FH.TOTAL_ORDER > 3000 AND II.INGREDIENT_TYPE = 'fruit_based'
ORDER BY FH.TOTAL_ORDER DESC

ORACLE

SELECT FH.FLAVOR
FROM FIRST_HALF FH JOIN ICECREAM_INFO II
ON FH.FLAVOR = II.FLAVOR
WHERE FH.TOTAL_ORDER > 3000 AND II.INGREDIENT_TYPE = 'fruit_based'
ORDER BY FH.TOTAL_ORDER DESC