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