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;