SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table mytable(id varchar(128), col1 int, col2 int, date1 date, date2 date, res int);
INSERT INTO mytable values('P4579841254',10,20,'01/02/1900','01/04/1914',10);
INSERT INTO mytable values('P4579841254',20,25,'01/03/1907','02/08/1918',57);
INSERT INTO mytable values('P4579841254',30,31,'01/04/1914','03/12/1922',459);
INSERT INTO mytable values('P4579841254',70,71,'01/05/1921','05/04/1927',7895);
INSERT INTO mytable values('P4579841254',70,71,'01/06/1921','05/06/1927',2497);
INSERT INTO mytable values('P4579841254',71,20,'01/06/1928','06/08/1931',1256);
INSERT INTO mytable values('P4579841254',20,75,'01/07/1935','07/12/1935',325987);
7 rows affected

WITH 
 min_d AS
  (SELECT min(m2.date1) d FROM mytable m2 WHERE m2.col1 = 70),
 max_d AS
  (SELECT max(m2.date2) d FROM mytable m2 WHERE m2.col2 = 75)
SELECT id, SUM(res)
FROM mytable
WHERE 
 date1 >= (SELECT d FROM min_d)
 AND (col1 <> 70 OR date1 = (SELECT d FROM min_d))
 AND date2 <= (SELECT d FROM max_d)
GROUP BY id


id
(No column name)


P4579841254
335138