SQLite 3.27

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

CREATE TABLE SUSPENSIONS (`ID_PROCESS` INTEGER, `DATA_BASE` TEXT, `DATA_SUSPENSION` TEXT);
INSERT INTO SUSPENSIONS (`ID_PROCESS`, `DATA_BASE`, `DATA_SUSPENSION`) VALUES
  ('31598', '2020-01-31', '2019-12-13'),
  ('31598', '2020-02-29', '2019-12-13'),
  ('31598', '2020-03-31', '2019-12-13'),
  ('31598', '2020-04-30', '2019-12-13'),
  ('104137', '2020-05-31', '2020-05-29'),
  ('31598', '2020-05-31', '2019-12-13'),
  ('104137', '2020-06-30', '2020-05-29'),
  ('31598', '2020-06-30', '2019-12-13'),
  ('31598', '2020-07-31', '2019-12-13'),
  ('2301194', '2021-02-28', '2021-02-26'),
  ('2301194', '2021-03-31', '2021-02-26'),
  ('251136', '2021-03-31', '2021-03-10'),
  ('2301194', '2021-04-30', '2021-02-26'),
  ('251136', '2021-04-30', '2021-03-10'),
  ('251136', '2021-05-31', '2021-03-10'),
  ('251136', '2021-06-30', '2021-03-10'),
  ('251136', '2021-07-31', '2021-03-10'),
  ('22324', '2018-04-30', '2018-04-27'),
  ('60947', '2019-11-30', '2019-11-08'),
  ('31598', '2019-12-31', '2019-12-13'),
  ('31598', '2020-08-31', '2020-08-26'),
  ('31598', '2020-09-30', '2020-08-26'),
  ('31598', '2020-10-31', '2020-08-26'),
  ('31598', '2020-11-30', '2020-08-26'),
  ('31598', '2020-12-31', '2020-08-26'),
  ('31598', '2021-01-31', '2020-08-26'),
  ('31598', '2021-02-28', '2020-08-26'),
  ('31598', '2021-03-31', '2020-08-26'),
  ('31598', '2021-04-30', '2020-08-26'),
  ('31598', '2021-05-31', '2020-08-26'),
  ('31598', '2021-06-30', '2020-08-26'),
  ('2301194', '2021-07-31', '2021-07-28'),
  ('31598', '2021-07-31', '2020-08-26'),
  ('2301194', '2021-08-31', '2021-07-28'),
  ('31598', '2021-08-31', '2020-08-26'),
  ('2301194', '2021-09-30', '2021-07-28'),
  ('251136', '2021-09-30', '2021-09-01'),
  ('31598', '2021-09-30', '2020-08-26');
WITH cte AS (
  SELECT DATA_SUSPENSION, 
         SUM(MAX(JULIANDAY(DATA_BASE) - JULIANDAY(DATA_SUSPENSION))) 
         OVER (ORDER BY DATA_SUSPENSION ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING) ACC_TIME_SUSPENSION
  FROM SUSPENSIONS 
  WHERE ID_PROCESS = 2301194  
  GROUP BY DATA_SUSPENSION
)
SELECT s.*, 
       JULIANDAY(s.DATA_BASE) - JULIANDAY(s.DATA_SUSPENSION) TIME_SUSPENSION,
       JULIANDAY(s.DATA_BASE) - JULIANDAY(s.DATA_SUSPENSION) + COALESCE(c.ACC_TIME_SUSPENSION, 0) TIME_AUX
FROM SUSPENSIONS s INNER JOIN cte c
ON c.DATA_SUSPENSION = s.DATA_SUSPENSION
ORDER BY s.DATA_BASE;


ID_PROCESS
DATA_BASE
DATA_SUSPENSION
TIME_SUSPENSION
TIME_AUX


2301194
2021-02-28
2021-02-26
2
2

2301194
2021-03-31
2021-02-26
33
33

2301194
2021-04-30
2021-02-26
63
63

2301194
2021-07-31
2021-07-28
3
66

2301194
2021-08-31
2021-07-28
34
97

2301194
2021-09-30
2021-07-28
64
127


WITH cte AS (
  SELECT ID_PROCESS, DATA_SUSPENSION, 
         SUM(MAX(JULIANDAY(DATA_BASE) - JULIANDAY(DATA_SUSPENSION))) 
         OVER (
           PARTITION BY ID_PROCESS 
           ORDER BY DATA_SUSPENSION ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING
         ) ACC_TIME_SUSPENSION
  FROM SUSPENSIONS 
  GROUP BY ID_PROCESS, DATA_SUSPENSION
)
SELECT s.*, 
       JULIANDAY(s.DATA_BASE) - JULIANDAY(s.DATA_SUSPENSION) TIME_SUSPENSION,
       JULIANDAY(s.DATA_BASE) - JULIANDAY(s.DATA_SUSPENSION) + COALESCE(c.ACC_TIME_SUSPENSION, 0) TIME_AUX
FROM SUSPENSIONS s INNER JOIN cte c
ON c.ID_PROCESS = s.ID_PROCESS AND c.DATA_SUSPENSION = s.DATA_SUSPENSION
ORDER BY s.ID_PROCESS, s.DATA_BASE;


ID_PROCESS
DATA_BASE
DATA_SUSPENSION
TIME_SUSPENSION
TIME_AUX


22324
2018-04-30
2018-04-27
3
3

31598
2019-12-31
2019-12-13
18
18

31598
2020-01-31
2019-12-13
49
49

31598
2020-02-29
2019-12-13
78
78

31598
2020-03-31
2019-12-13
109
109

31598
2020-04-30
2019-12-13
139
139

31598
2020-05-31
2019-12-13
170
170

31598
2020-06-30
2019-12-13
200
200

31598
2020-07-31
2019-12-13
231
231

31598
2020-08-31
2020-08-26
5
236

31598
2020-09-30
2020-08-26
35
266

31598
2020-10-31
2020-08-26
66
297

31598
2020-11-30
2020-08-26
96
327

31598
2020-12-31
2020-08-26
127
358

31598
2021-01-31
2020-08-26
158
389

31598
2021-02-28
2020-08-26
186
417

31598
2021-03-31
2020-08-26
217
448

31598
2021-04-30
2020-08-26
247
478

31598
2021-05-31
2020-08-26
278
509

31598
2021-06-30
2020-08-26
308
539

31598
2021-07-31
2020-08-26
339
570

31598
2021-08-31
2020-08-26
370
601

31598
2021-09-30
2020-08-26
400
631

60947
2019-11-30
2019-11-08
22
22

104137
2020-05-31
2020-05-29
2
2

104137
2020-06-30
2020-05-29
32
32

251136
2021-03-31
2021-03-10
21
21

251136
2021-04-30
2021-03-10
51
51

251136
2021-05-31
2021-03-10
82
82

251136
2021-06-30
2021-03-10
112
112

251136
2021-07-31
2021-03-10
143
143

251136
2021-09-30
2021-09-01
29
172

2301194
2021-02-28
2021-02-26
2
2

2301194
2021-03-31
2021-02-26
33
33

2301194
2021-04-30
2021-02-26
63
63

2301194
2021-07-31
2021-07-28
3
66

2301194
2021-08-31
2021-07-28
34
97

2301194
2021-09-30
2021-07-28
64
127

ID_PROCESS	DATA_BASE	DATA_SUSPENSION	TIME_SUSPENSION	TIME_AUX
2301194	2021-02-28	2021-02-26	2	2
2301194	2021-03-31	2021-02-26	33	33
2301194	2021-04-30	2021-02-26	63	63
2301194	2021-07-31	2021-07-28	3	66
2301194	2021-08-31	2021-07-28	34	97
2301194	2021-09-30	2021-07-28	64	127

ID_PROCESS	DATA_BASE	DATA_SUSPENSION	TIME_SUSPENSION	TIME_AUX
22324	2018-04-30	2018-04-27	3	3
31598	2019-12-31	2019-12-13	18	18
31598	2020-01-31	2019-12-13	49	49
31598	2020-02-29	2019-12-13	78	78
31598	2020-03-31	2019-12-13	109	109
31598	2020-04-30	2019-12-13	139	139
31598	2020-05-31	2019-12-13	170	170
31598	2020-06-30	2019-12-13	200	200
31598	2020-07-31	2019-12-13	231	231
31598	2020-08-31	2020-08-26	5	236
31598	2020-09-30	2020-08-26	35	266
31598	2020-10-31	2020-08-26	66	297
31598	2020-11-30	2020-08-26	96	327
31598	2020-12-31	2020-08-26	127	358
31598	2021-01-31	2020-08-26	158	389
31598	2021-02-28	2020-08-26	186	417
31598	2021-03-31	2020-08-26	217	448
31598	2021-04-30	2020-08-26	247	478
31598	2021-05-31	2020-08-26	278	509
31598	2021-06-30	2020-08-26	308	539
31598	2021-07-31	2020-08-26	339	570
31598	2021-08-31	2020-08-26	370	601
31598	2021-09-30	2020-08-26	400	631
60947	2019-11-30	2019-11-08	22	22
104137	2020-05-31	2020-05-29	2	2
104137	2020-06-30	2020-05-29	32	32
251136	2021-03-31	2021-03-10	21	21
251136	2021-04-30	2021-03-10	51	51
251136	2021-05-31	2021-03-10	82	82
251136	2021-06-30	2021-03-10	112	112
251136	2021-07-31	2021-03-10	143	143
251136	2021-09-30	2021-09-01	29	172
2301194	2021-02-28	2021-02-26	2	2
2301194	2021-03-31	2021-02-26	33	33
2301194	2021-04-30	2021-02-26	63	63
2301194	2021-07-31	2021-07-28	3	66
2301194	2021-08-31	2021-07-28	34	97
2301194	2021-09-30	2021-07-28	64	127