Firebird 4.0

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

create table tbtrades(id_trade integer, ENTRY_DATE date, EXIT_DATE date, Ergebnis NUMERIC(9,2), zuKonto VARCHAR(3))
EXECUTE BLOCK AS BEGIN
insert into tbtrades values(1, CURRENT_DATE-50, CURRENT_DATE-50, 10, '3');
insert into tbtrades values(2, CURRENT_DATE-50, CURRENT_DATE-40, 20, '4');
insert into tbtrades values(3, CURRENT_DATE-50, CURRENT_DATE-30, 30, '3');
insert into tbtrades values(4, CURRENT_DATE-50, CURRENT_DATE-20, 40, '4');
insert into tbtrades values(5, CURRENT_DATE-50, CURRENT_DATE-10, 50, '3');
END
5 rows affected

SELECT id_trade, EXIT_DATE, Ergebnis, SUM(Ergebnis) OVER(PARTITION BY zuKonto ORDER BY EXIT_DATE, id_trade) AS SumTotal
FROM tbtrades
WHERE (Entry_Date >='27.12.2022' AND Exit_Date <= '31.03.2023') AND
          zuKonto = '4'
ORDER BY EXIT_DATE, id_trade



ID_TRADE
EXIT_DATE
ERGEBNIS
SUMTOTAL


2
2023-02-15
20.00
20.00

4
2023-03-07
40.00
60.00