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;