select 

    ITEM_POPULAR_RANK as RANK,
    ITEM_CODE as CODE,
    ITEM_NAME as NAME

from item
where sale_end_date is null
order by 1;