Connected to Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 

SQL> 
with t as (
select 1 r, to_date('01.01.2018', 'dd.mm.yyyy') d, 0 s, 100 n from dual union all
select 2 r, to_date('01.01.2018', 'dd.mm.yyyy') d, 0 s, 150 n from dual union all
select 3 r, to_date('02.01.2018', 'dd.mm.yyyy') d, 1 s, 200 n from dual union all
select 4 r, to_date('02.01.2018', 'dd.mm.yyyy') d, 1 s, 250 n from dual union all
select 5 r, to_date('03.01.2018', 'dd.mm.yyyy') d, 7 s, 300 n from dual union all
select 8 r, to_date('01.02.2018', 'dd.mm.yyyy') d, 2 s, 400 n from dual union all
select 9 r, to_date('01.02.2018', 'dd.mm.yyyy') d, 3 s, 400 n from dual union all
select 10 r, to_date('01.02.2018', 'dd.mm.yyyy') d, 31 s, 400 n from dual union all
select 11 r, to_date('01.02.2018', 'dd.mm.yyyy') d, 1 s, 400 n from dual union all
select 12 r, to_date('01.03.2018', 'dd.mm.yyyy') d, 3 s, 500 n from dual union all
select 13 r, to_date('02.05.2018', 'dd.mm.yyyy') d, 3 s, 1 n from dual
)
select r_range, sum_n, d_from, d_to
  from t MATCH_RECOGNIZE (
 order by r
measures first(strt.r) ||'-'|| last(stp.r) as r_range
       , min(strt.d) as d_from
       , max(stp.d) as d_to
       , nvl(sum(s_member.n),0)+sum(strt.n) as sum_n
one row per match
after match skip past last row
pattern ( strt s_member* stp )
define strt as s = 1
     , stp as s = 3
     , s_member as s <> 3
) MR;
R_RANGE      SUM_N D_FROM      D_TO
------- ---------- ----------- -----------
3-9           1150 02.01.2018  01.02.2018
11-12          400 01.02.2018  01.03.2018

SQL>