SELECT
A.ITEM_POPULAR_RANK AS 'RANK',
A.ITEM_CODE AS 'CODE',
A.ITEM_NAME AS 'NAME',
A.RECOMMEND_ITEM_RANK AS 'RCM_RANK'
FROM ITEM A
ORDER BY 
RANK ASC,
CODE DESC
;