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

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

프로그래머스

 

내 풀이

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