[programmers] 과일로 만든 아이스크림 고르기

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

틀렸다.

SQL 실행 중 오류가 발생하였습니다. Not unique table/alias: 'ICECREAM_INFO'

 

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