[프로그래머스, 133025] 과일로 만든 아이스크림 고르기 (mysql)

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

프로그래머스

728x90

---

SELECT fh.flavor
FROM first_half as fh
LEFT 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;