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,ITEM_CODE;