출처

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

문제

풀이

SELECT
    I.ITEM_ID,
    I.ITEM_NAME,
    I.RARITY
FROM 
    ITEM_INFO I
LEFT JOIN
    ITEM_TREE T
ON 
    I.ITEM_ID = T.PARENT_ITEM_ID
WHERE
    T.PARENT_ITEM_ID IS NULL
ORDER BY
    1 DESC