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
   ;