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