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