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