--商品テーブル(ITEM)より、人気順(ITEM_POPULAR_RANKの昇順)
--ITEM_POPULAR_RANKの昇順
--ITEM_CODEの昇順

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;