📌[SQL 문제 풀이] Programmers - 과일로 만든 아이스크림 고르기

💻 문제

✍️ 정답

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