w ith t
as (select list_code,
           shop_no,
           week,
           week - row_number() over (order by list_code, shop_no, week) grp
    from list.imp_shops
    where list_code =
    (
        select list_code from list.list where list_name = 'mmm'
    )
   ),
     tst
as (select list_code,
           shop_no,
           min(week) week_start,
           max(week) week_end
    from t
    group by list_code,
             shop_no,
             grp
   )
select shop_NO as "CF shop",
       b.sri_list_shop_NO as "shop",
       WEEK_END as "Report Week" ,
       ((week_end - week_start) + 1) as "Copies",
       (select WEEK_REASON from list.imp_shops c where c.shop_no = a.shop_no and week = 2295) "Latest "
from tst a JOIN  euroscan b on a.shop_no = b.list_shop_no
where week_start <= 2295
      and week_end = 2295 and b.list_file_abbrev =
      (
           select list_code from list.list where list_name = 'mmm'
      )  
order by shop_no,
         list_code;

SELECT DISTINCT 
  shop_NO as "CF shop", ...