[프로그래머스]SQL 고득점 Kit: 과일로 만든 아이스크림 고르기

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

프로그래머스

 

-- 코드를 입력하세요
SELECT FIRST_HALF.FLAVOR
from FIRST_HALF join ICECREAM_INFO on FIRST_HALF.FLAVOR = ICECREAM_INFO.FLAVOR
where TOTAL_ORDER > 3000 and ICECREAM_INFO.INGREDIENT_TYPE = 'fruit_based'
order by TOTAL_ORDER desc