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;