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