select  I.ITEM_POPULAR_RANK AS "RANK"
        ,I.ITEM_CODE AS "CODE"
        ,I.ITEM_NAME AS "NAME"
  from  ITEM I
 WHERE  I.SALE_END_DATE IS NULL
 order by ITEM_POPULAR_RANK