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;