Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytable(
   ID    INTEGER  NOT NULL 
  ,SEQ   INTEGER  NOT NULL
  ,LABEL INTEGER  NOT NULL
  ,COUNT1 INTEGER  NOT NULL
);
begin
INSERT INTO mytable(ID,SEQ,LABEL,COUNT1) VALUES (1,1,0,3);
INSERT INTO mytable(ID,SEQ,LABEL,COUNT1) VALUES (1,2,0,2);
INSERT INTO mytable(ID,SEQ,LABEL,COUNT1) VALUES (1,3,0,6);
INSERT INTO mytable(ID,SEQ,LABEL,COUNT1) VALUES (1,4,1,2);
INSERT INTO mytable(ID,SEQ,LABEL,COUNT1) VALUES (1,5,0,3);
INSERT INTO mytable(ID,SEQ,LABEL,COUNT1) VALUES (1,6,0,5);
INSERT INTO mytable(ID,SEQ,LABEL,COUNT1) VALUES (2,1,0,2);
INSERT INTO mytable(ID,SEQ,LABEL,COUNT1) VALUES (2,2,1,1);
INSERT INTO mytable(ID,SEQ,LABEL,COUNT1) VALUES (2,3,0,3);
end;
/
1 rows affected

select 
    t.*,
    sum(count1) over(partition by id, grp order by seq) running_count
from (
    select 
        t.*,
        sum(label) over(partition by id order by seq desc) grp
    from mytable t
) t
order by id, seq


ID
SEQ
LABEL
COUNT1
GRP
RUNNING_COUNT


1
1
0
3
1
3

1
2
0
2
1
5

1
3
0
6
1
11

1
4
1
2
1
13

1
5
0
3
0
3

1
6
0
5
0
8

2
1
0
2
1
2

2
2
1
1
1
3

2
3
0
3
0
3