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
;