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