select
  ITEM_POPULAR_RANK asRANK
, 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;