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
;