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