SQL> ed
Wrote file afiedt.buf

  1  with
  2  pm_t1(server_id,budget) as(
  3    select 1,100 from dual union all
  4    select 2,200 from dual union all
  5    select 3,300 from dual )
  6  ,bittl_t2 (server_id,street_Id) as(
  7    select 1,11 from dual union all
  8    select 2,11 from dual union all
  9    select 3,33 from dual)
 10  ,pm_t3(street_Id,create_date) as(
 11    select 11,date '2020-08-07' from dual union all
 12    select 33,date '2020-09-01' from dual )
 13  --
 14  select --a.budget, a.server_id, c.street_id
 15    c.street_id,sum(a.budget) sum_budget
 16  from pm_t1 a, bittl_t2 b, pm_t3 c
 17  where a.server_id = b.server_id
 18    and b.street_Id = c.street_id
 19    and c.create_date >=date '2020-08-01' and c.create_date < date '2020-09-01'
 20* group by c.street_id
SQL> /

 STREET_ID SUM_BUDGET
---------- ----------
        11        300