select 
 ITEM_POPULAR_RANK as RANK
 ,ITEM_CODE as CODE
 ,ITEM_NAME as NAME
from item
where
 SALE_END_DATE IS NULL
order by 
 RANK asc,
 CODE asc;