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