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