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;