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 RANK