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