SELECT ITEM_POPULAR_RANK AS RANK,
       ITEM_CODE AS CODE,
       ITEM_NAME AS NAME 
    
FROM  ITEM 

WHERE SALE_END_DATE IS NULL 

ORDER BY
    ITEM_POPULAR_RANK ASC , ITEM_CODE ASC;