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