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;