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;