select
    ITEM_POPULAR_RANK as RANK
    ,item_code as CODE 
    ,item_name as NAME
from
    ITEM
where
    sale_end_date is null
order by 1,2
;