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;