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 ASC
,ITEM_CODE ASC;