[SELECT, IN] 업그레이드 된 아이템 구하기

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

프로그래머스

 

레벨2

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