SELECT
    ITEM_POPULAR_RANK as RANK
    , ITEM_CODE as CODE
    , ITEM_NAME as NAME
    , RECOMMEND_ITEM_RANK as RCM_RANK
FROM
    ITEM
ORDER BY
    ITEM_POPULAR_RANK
    , ITEM_CODE DESC;