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;