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;