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
;