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
  , ITEM_CODE  desc
;