프로그래머스 - 업그레이드 된 아이템 구하기

SELECT I.ITEM_ID, I.ITEM_NAME, I.RARITY
FROM ITEM_TREE T
JOIN ITEM_INFO AS I ON T.ITEM_ID = I.ITEM_ID
WHERE T.PARENT_ITEM_ID IN (
    SELECT ITEM_ID FROM ITEM_INFO WHERE RARITY = 'RARE'
)
ORDER BY I.ITEM_ID DESC;