select
          Item_Popular_rank "RANK"
         ,item_code CODE
         ,item_name NAME
    from
        Item
    where
        Sale_end_date is NULL
    ORDER BY
        item_popular_rank, item_code