👩‍💻 문제

https://school.programmers.co.kr/learn/courses/30/lessons/133025?language=mysql

🙋‍♀️ 답변

SELECT I.FLAVOR
FROM FIRST_HALF F JOIN ICECREAM_INFO I
ON F.FLAVOR = I.FLAVOR
WHERE INGREDIENT_TYPE = 'FRUIT_BASED' 
AND TOTAL_ORDER > 3000
ORDER BY TOTAL_ORDER DESC;

🤔

와웅 오랜만에 sql 했더니 기억이 하나도 안난다,,,,,,,,, 대박!