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 ASC
    -- 商品コードは降順指定になっているので気を付けましょう
    , ITEM_CODE DESC;