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;