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 ASC, RECOMMEND_ITEM_RANK DESC;