과일로 만든 아이스크림 고르기 mysql

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

SELECT H.FLAVOR
FROM FIRST_HALF AS H
JOIN ICECREAM_INFO AS I ON H.FLAVOR = I.FLAVOR
WHERE H.TOTAL_ORDER > 3000 and I.INGREDIENT_TYPE like 'fruit_based'
ORDER BY H.TOTAL_ORDER desc

1. JOIN
2. WHERE
3. ORDER BY