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;