MySQL 8.0

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

CREATE TABLE deals(
Deal varchar(15) ,
Closing_date   varchar(50),
Revenue_won int );

insert into deals values
("Deal #1",'01/jan/2022','500'),
("Deal #2",'01/jan/2022','500'),
("Deal #3",'02/jan/2022','1500'),
("Deal #4",'02/jan/2022','500');

CREATE TABLE churns(
Churn varchar(15) ,
Closing_date   varchar(50),
Revenue_lost int );

insert into churns values
('Churn #1','01/jan/2022','-500'),
('Churn #2','02/jan/2022','-100'),
('Churn #3','02/jan/2022','-100');

CREATE TABLE upsells(
Upsell varchar(15) ,
Closing_date   varchar(50),
Revenue_won int );

insert into upsells values
('Upsell #1','01/jan/2022','2000'),
('Upsell #2','01/jan/2022','-1000'),
('Upsell #3','02/jan/2022','2000');

select * from deals;
select * from churns;
select * from upsells;


Deal
Closing_date
Revenue_won


Deal #1
01/jan/2022
500

Deal #2
01/jan/2022
500

Deal #3
02/jan/2022
1500

Deal #4
02/jan/2022
500




Churn
Closing_date
Revenue_lost


Churn #1
01/jan/2022
-500

Churn #2
02/jan/2022
-100

Churn #3
02/jan/2022
-100




Upsell
Closing_date
Revenue_won


Upsell #1
01/jan/2022
2000

Upsell #2
01/jan/2022
-1000

Upsell #3
02/jan/2022
2000


select d.Closing_date,
       sum(d.Revenue_won) as 'Revenue gained from new deals', 
       c.`Revenue lost from churn`,
       u.`Revenue gained from upsell`
from deals d
inner join ( select Closing_date,
                    sum(Revenue_lost) as 'Revenue lost from churn'
            from churns 
            group by Closing_date 
            ) as c on c.Closing_date=d.Closing_date
inner join ( select Closing_date,
                    sum(Revenue_won) as 'Revenue gained from upsell'
             from upsells u 
             group by Closing_date 
             ) as u on  u.Closing_date=d.Closing_date          
group by d.Closing_date ;
      


Closing_date
Revenue gained from new deals
Revenue lost from churn
Revenue gained from upsell


01/jan/2022
1000
-500
1000

02/jan/2022
2000
-200
2000

Deal	Closing_date	Revenue_won
Deal #1	01/jan/2022	500
Deal #2	01/jan/2022	500
Deal #3	02/jan/2022	1500
Deal #4	02/jan/2022	500

Churn	Closing_date	Revenue_lost
Churn #1	01/jan/2022	-500
Churn #2	02/jan/2022	-100
Churn #3	02/jan/2022	-100

Upsell	Closing_date	Revenue_won
Upsell #1	01/jan/2022	2000
Upsell #2	01/jan/2022	-1000
Upsell #3	02/jan/2022	2000