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
;