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 asc
, ITEM_CODE asc