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