SQL Server 2019

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

CREATE TABLE SampleExample (
    [Seconds] INT,
    [Sequence] INT,
    [Value] NUMERIC(12, 9),
    [Result] NVARCHAR(4)
);
INSERT INTO SampleExample VALUES
    (598,1,236.888453364,N'#N/A'),
    (740,2,236.888453364,N'True'),
    (885,3,235.463708639,N'True'),
    (1024,4,236.177295446,N'True'),
    (1189,5,236.177295446,N'True'),
    (1330,6,236.866638064,N'True'),
    (1463,7,236.177295446,N'True'),
    (1599,8,236.866638064,N'True'),
    (1735,9,236.866638064,N'True'),
    (1863,10,236.866638064,N'True'),
    (1986,11,236.866638064,N'True'),
    (2110,12,236.866638064,N'True'),
    (2235,13,236.880749464,N'True'),
    (2362,14,236.908763647,N'True'),
    (2487,15,236.908763647,N'True'),
    (2610,16,236.908763647,N'True'),
    (2739,17,237.190827727,N'True'),
    (2865,18,237.190827727,N'True'),
    (3008,19,237.190827727,N'True'),
    (3132,20,237.190827727,N'True');
20 rows affected

select se.*,
       avg(value) over (order by sequence) as avg_value,
       percentile_cont(0.5) over (within group order by sequence) over (order by sequence)
from sampleexample se
Msg 102 Level 15 State 1 Line 3
Incorrect syntax near 'within'.

select se.*, se2.*
from sampleexample se cross apply
     (select top (1)  percentile_cont(0.5) within group (order by value) over () as median,
             avg(value) over () as avg_value
      from sampleexample se2
      where se2.sequence <= se.sequence
     ) se2


Seconds
Sequence
Value
Result
median
avg_value


598
1
236.888453364
#N/A
236.888453364
236.888453364

740
2
236.888453364
True
236.888453364
236.888453364

885
3
235.463708639
True
236.888453364
236.413538455

1024
4
236.177295446
True
236.532874405
236.354477703

1189
5
236.177295446
True
236.177295446
236.319041251

1330
6
236.866638064
True
236.521966755
236.410307387

1463
7
236.177295446
True
236.177295446
236.377019967

1599
8
236.866638064
True
236.521966755
236.438222229

1735
9
236.866638064
True
236.866638064
236.485823988

1863
10
236.866638064
True
236.866638064
236.523905396

1986
11
236.866638064
True
236.866638064
236.555062911

2110
12
236.866638064
True
236.866638064
236.581027507

2235
13
236.880749464
True
236.866638064
236.604083042

2362
14
236.908763647
True
236.866638064
236.625845942

2487
15
236.908763647
True
236.866638064
236.644707123

2610
16
236.908763647
True
236.866638064
236.661210655

2739
17
237.190827727
True
236.866638064
236.692364601

2865
18
237.190827727
True
236.866638064
236.720056997

3008
19
237.190827727
True
236.866638064
236.744834403

3132
20
237.190827727
True
236.873693764
236.767134070


select se.*, se2.*
from sampleexample se cross apply
     (select top (1) percentile_cont(0.5) within group (order by value) over () as median,
             avg(value) over () as avg_value,
             value as mode
      from (select se2.*, count(*) over (partition by se2.value) as value_cnt
            from sampleexample se2
            where se2.sequence <= se.sequence
           ) se2
      order by se2.value_cnt desc
     ) se2


Seconds
Sequence
Value
Result
median
avg_value
mode


598
1
236.888453364
#N/A
236.888453364
236.888453364
236.888453364

740
2
236.888453364
True
236.888453364
236.888453364
236.888453364

885
3
235.463708639
True
236.888453364
236.413538455
236.888453364

1024
4
236.177295446
True
236.532874405
236.354477703
236.888453364

1189
5
236.177295446
True
236.177295446
236.319041251
236.177295446

1330
6
236.866638064
True
236.521966755
236.410307387
236.177295446

1463
7
236.177295446
True
236.177295446
236.377019967
236.177295446

1599
8
236.866638064
True
236.521966755
236.438222229
236.177295446

1735
9
236.866638064
True
236.866638064
236.485823988
236.177295446

1863
10
236.866638064
True
236.866638064
236.523905396
236.866638064

1986
11
236.866638064
True
236.866638064
236.555062911
236.866638064

2110
12
236.866638064
True
236.866638064
236.581027507
236.866638064

2235
13
236.880749464
True
236.866638064
236.604083042
236.866638064

2362
14
236.908763647
True
236.866638064
236.625845942
236.866638064

2487
15
236.908763647
True
236.866638064
236.644707123
236.866638064

2610
16
236.908763647
True
236.866638064
236.661210655
236.866638064

2739
17
237.190827727
True
236.866638064
236.692364601
236.866638064

2865
18
237.190827727
True
236.866638064
236.720056997
236.866638064

3008
19
237.190827727
True
236.866638064
236.744834403
236.866638064

3132
20
237.190827727
True
236.873693764
236.767134070
236.866638064


select value, count(*)
from sampleexample
group by value


value
(No column name)


235.463708639
1

236.177295446
3

236.866638064
6

236.880749464
1

236.888453364
2

236.908763647
3

237.190827727
4

Seconds	Sequence	Value	Result	median	avg_value
598	1	236.888453364	#N/A	236.888453364	236.888453364
740	2	236.888453364	True	236.888453364	236.888453364
885	3	235.463708639	True	236.888453364	236.413538455
1024	4	236.177295446	True	236.532874405	236.354477703
1189	5	236.177295446	True	236.177295446	236.319041251
1330	6	236.866638064	True	236.521966755	236.410307387
1463	7	236.177295446	True	236.177295446	236.377019967
1599	8	236.866638064	True	236.521966755	236.438222229
1735	9	236.866638064	True	236.866638064	236.485823988
1863	10	236.866638064	True	236.866638064	236.523905396
1986	11	236.866638064	True	236.866638064	236.555062911
2110	12	236.866638064	True	236.866638064	236.581027507
2235	13	236.880749464	True	236.866638064	236.604083042
2362	14	236.908763647	True	236.866638064	236.625845942
2487	15	236.908763647	True	236.866638064	236.644707123
2610	16	236.908763647	True	236.866638064	236.661210655
2739	17	237.190827727	True	236.866638064	236.692364601
2865	18	237.190827727	True	236.866638064	236.720056997
3008	19	237.190827727	True	236.866638064	236.744834403
3132	20	237.190827727	True	236.873693764	236.767134070