select ITEM_POPULAR_RANK +1 as RANK,
ITEM_CODE as CODE,
ITEM_NAME as NAME
from item 
where SALE_END_DATE is not  null
order by
ITEM_POPULAR_RANK ASC,
ITEM_CODE ASC