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;