업그레이드 된 아이템 구하기

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