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;