select ITEM_POPULAR_RANK as RANK
     , ITEM_CODE as CODE
     , ITEM_NAME as NAME
  from ITEM
 where SALE_END_DATE > CURRENT_DATE or SALE_END_DATE is null
 order by ITEM_POPULAR_RANK asc, ITEM_CODE asc