[프로그래머스][MySQL] Lv. 1 과일로 만든 아이스크림 고르기

문제 설명

https://school.programmers.co.kr/learn/courses/30/lessons/133025

프로그래머스

 

내 풀이

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