SELECT ITEM_POPULAR_RANK RANK,ITEM_CODE CODE,ITEM_NAME NAME
FROM ITEM
WHERE SALE_END_DATE IS NOT NULL
ORDER BY ITEM_POPULAR_RANK,ITEM_CODE