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