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
;