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, ITEM_CODE desc
;