select
  ITEM_POPULAR_RANK as "RANK"
 ,ITEM_CODE as "CODE"
 ,ITEM_NAME as "NAME"
from
 ITEM
where
 SALE_END_DATE is null
order by
 "RANK" asc, "CODE" asc
;