SELECT
	ITEM_POPULAR_RANK ASRANK
,	ITEM_CODE AS CODE
,	ITEM_NAME AS NAME	
FROM
	ITEM
WHERE
	SALE_END_DATE IS NULL
ORDER BY
	ITEM_POPULAR_RANK
,	ITEM_CODE