select ITEM_POPULAR_RANK as "人気順位", ITEM_CODE as "商品コード", ITEM_NAME as "商品名称", RECOMMEND_ITEM_RANK as "おすすめ商品順位"
from ITEM
order by ITEM_POPULAR_RANK, ITEM_CODE desc;