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;