select
    item_popular_rank RANK
    ,item_code CODE
    ,ITEM_NAME NAME
from
    item
where
    sale_end_date is null
order by
    item_popular_rank, item_code
;