SQL Server 2019

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

create table people (fullname varchar(20), numberofoutstanding int)
insert into people values ('aa', 27)
1 rows affected

insert into people values ('bb', 4)
1 rows affected

insert into people values ('cc', 11)
1 rows affected

create table outstandingpunches (fullname varchar(20), date_c date)
insert into outstandingpunches values ('aa', '02.10.2020')
1 rows affected

insert into outstandingpunches values ('bb', '03.10.2020')
1 rows affected

insert into outstandingpunches values ('cc', '04.10.2020')
1 rows affected

select o.date_c, 
       sum(sum(p.numberofoutstanding)) over (order by o.date_c)
from people p 
left join outstandingpunches o on p.fullname = o.fullname
group by o.date_c;


date_c
(No column name)


2020-02-10
27

2020-03-10
31

2020-04-10
42