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

WHERE SALE_END_DATE IS NULL

ORDER BY ITEM_POPULAR_RANK ASC,ITEM_CODE ASC;