select i.ITEM_POPULAR_RANK  as RANK, i.item_code as CODE, i.item_name as NAME
From ITEM i where i.SALE_END_DATE IS NOT NULL ORDER BY i.ITEM_POPULAR_RANK  ASC;