select
    i.item_popular_rank AS RANK
    ,i.item_code AS CODE
    ,i.item_name AS NAME
    ,i.recommend_item_rank AS RCM_RANK
from
    item i
order by
    RANK ASC
    ,ITEM_CODE DESC