create table donor (donor_Id number, amount number, date_donated date);
   
insert into donor values (1, 700, trunc(sysdate));
insert into donor values (1, 500, trunc(sysdate)-1);
insert into donor values (1, 600, trunc(sysdate)-2);
insert into donor values (1, 400, trunc(sysdate)-3);
   
create table req_donation (donor_id number, req_amount number);
   
insert into req_donation values (1, 1400);
   
select donor_id, req_amount, max_donation
from
  (select d.donor_id, r.req_amount, sum(d.amount) over   
      (partition by d.donor_id order by d.date_donated) as max_donation
   from donor D, req_donation r
   where d.donor_id = r.donor_id)
   where max_donation < req_amount;