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;