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;