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