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;