SQLite 3.27

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

CREATE TABLE MY_TABLE(
  "Group" TEXT,
  Callees INTEGER,
  Callers INTEGER
  );
  
✓
INSERT INTO MY_TABLE("Group", Callees, Callers) VALUES ('Group1', 1, 505),
('Group1', 2, 172),
('Group1', 3, 33),
('Group1', 4, 20),
('Group1', 5, 5),
('Group1', 6, 5),
('Group1', 7, 3),
('Group1', 8, 4),
('Group1', 9, 3),
('Group1', 10, 2),
('Group1', 11, 1),
('Group1', 13, 1),
('Group1', 14, 1),
('Group1', 16, 1),
('Group1', 22, 2);
✓
select "Group", Callees,mt.Callers,
--the below one gives cumulative sum as the default window frame is Bewtween UNBOUNDED PRECEDING AND CURRENT ROW
SUM(callers) OVER(Partition By "Group" order by Callees) as cumulative_sum, 
--the below one gives total_sum
SUM(callers) OVER(Partition By "Group" RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as Total_sum 
from MY_TABLE mt
order by "Group", Callees


Group
Callees
Callers
cumulative_sum
Total_sum


Group1
1
505
505
758

Group1
2
172
677
758

Group1
3
33
710
758

Group1
4
20
730
758

Group1
5
5
735
758

Group1
6
5
740
758

Group1
7
3
743
758

Group1
8
4
747
758

Group1
9
3
750
758

Group1
10
2
752
758

Group1
11
1
753
758

Group1
13
1
754
758

Group1
14
1
755
758

Group1
16
1
756
758

Group1
22
2
758
758


select "Group", Callees,mt.Callers,
ROUND((sum(callers) over(Partition By "Group" order by Callees) * 1.00) / (sum(callers) over (Partition By "Group" RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)),4) CumulativeP
from MY_TABLE mt
order by "Group", Callees


Group
Callees
Callers
CumulativeP


Group1
1
505
0.6662

Group1
2
172
0.8931

Group1
3
33
0.9367

Group1
4
20
0.9631

Group1
5
5
0.9697

Group1
6
5
0.9763

Group1
7
3
0.9802

Group1
8
4
0.9855

Group1
9
3
0.9894

Group1
10
2
0.9921

Group1
11
1
0.9934

Group1
13
1
0.9947

Group1
14
1
0.996

Group1
16
1
0.9974

Group1
22
2
1

Group	Callees	Callers	cumulative_sum	Total_sum
Group1	1	505	505	758
Group1	2	172	677	758
Group1	3	33	710	758
Group1	4	20	730	758
Group1	5	5	735	758
Group1	6	5	740	758
Group1	7	3	743	758
Group1	8	4	747	758
Group1	9	3	750	758
Group1	10	2	752	758
Group1	11	1	753	758
Group1	13	1	754	758
Group1	14	1	755	758
Group1	16	1	756	758
Group1	22	2	758	758

Group	Callees	Callers	CumulativeP
Group1	1	505	0.6662
Group1	2	172	0.8931
Group1	3	33	0.9367
Group1	4	20	0.9631
Group1	5	5	0.9697
Group1	6	5	0.9763
Group1	7	3	0.9802
Group1	8	4	0.9855
Group1	9	3	0.9894
Group1	10	2	0.9921
Group1	11	1	0.9934
Group1	13	1	0.9947
Group1	14	1	0.996
Group1	16	1	0.9974
Group1	22	2	1