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