Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table YourTable (ID, Value, Timestamp, Delay) as (
select 166549627, 4, to_date('19-OCT-21 11:00:19', 'DD-MON-RR HH24:MI:SS', 'nls_date_language=english'), 11.4 from dual union all
select 166549450, 8, to_date('19-OCT-21 11:00:27', 'DD-MON-RR HH24:MI:SS', 'nls_date_language=english'), 7.5  from dual union all
select 166549446, 3, to_date('19-OCT-21 11:00:34', 'DD-MON-RR HH24:MI:SS', 'nls_date_language=english'), 7.1  from dual union all
select 166549625, 3, to_date('19-OCT-21 11:00:45', 'DD-MON-RR HH24:MI:SS', 'nls_date_language=english'), 10.9 from dual union all
select 166549631, 3, to_date('19-OCT-21 11:00:58', 'DD-MON-RR HH24:MI:SS', 'nls_date_language=english'), 13.3 from dual union all
select 166550549, 3, to_date('19-OCT-21 11:01:03', 'DD-MON-RR HH24:MI:SS', 'nls_date_language=english'), 4.5  from dual union all
select 166549618, 7, to_date('19-OCT-21 11:01:14', 'DD-MON-RR HH24:MI:SS', 'nls_date_language=english'), 8.8  from dual union all
select 166549627, 4, to_date('19-OCT-21 11:01:23', 'DD-MON-RR HH24:MI:SS', 'nls_date_language=english'), 11.4 from dual union all
select 166550549, 3, to_date('19-OCT-21 11:01:45', 'DD-MON-RR HH24:MI:SS', 'nls_date_language=english'), 4.5  from dual union all
select 166550549, 3, to_date('19-OCT-21 11:01:59', 'DD-MON-RR HH24:MI:SS', 'nls_date_language=english'), 4.5  from dual
)
;

10 rows affected

VALUE	SUM_CONSECUTIVE_DELAY	MIN_TIMESTAMP	MAX_TIMESTAMP	NB_ROWS
4	11.4	19-OCT-21	19-OCT-21	1
8	7.5	19-OCT-21	19-OCT-21	1
3	35.8	19-OCT-21	19-OCT-21	4
7	8.8	19-OCT-21	19-OCT-21	1
4	11.4	19-OCT-21	19-OCT-21	1
3	9	19-OCT-21	19-OCT-21	2