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 ASC
    ,CODE ASC;