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