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;