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