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;