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,ITEM_CODE ASC ;