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;