select  ITEM_POPULAR_RANK as RANK,
        ITEM_CODE as CODE,
        ITEM_NAME as NAME
from    ITEM
where   SALE_END_DATE is not null
order by ITEM_POPULAR_RANK
and     ITEM_CODE