MySQL 8.0

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

CREATE TABLE app_company (
  idcompany int,
  company varchar(50) );

insert into app_company  values
(1,'APPLE'),
(2,'GOOGLE'),
(3,'MICROSOFT'),
(4,'STEAM'),
(5,'AMAZON'),
(6,'LG');

CREATE TABLE app_pay(
  id int,
  company varchar(50),
  dueday date, 
  valuep decimal (5,2));

insert into app_pay values
(1,'APPLE','2022-10-03',200.00),
(2,'APPLE','2022-10-04',600.00),
(3,'GOOGLE','2022-10-04',600.00),
(4,'MICROSOFT','2022-10-04',500.00),
(5,'MICROSOFT','2022-10-04',60.00),
(6,'APPLE','2022-10-04',100.00);



CREATE TABLE app_receive(
  idconta int,
  company varchar(50),
  issuedate date,
  valuer decimal (7,2) );

insert into app_receive values
(104,'MICROSOFT','2022-10-03',70000.00),
(106,'STEAM','2022-10-03',15000.00),
(107,'STEAM','2022-10-03',42000.00),
(108,'AMAZON','2022-10-03',46000.00),
(109,'LG','2022-10-03',3200.00);

Records: 6  Duplicates: 0  Warnings: 0



Records: 6  Duplicates: 0  Warnings: 0



Records: 5  Duplicates: 0  Warnings: 0


select * from app_company ;
select * from app_pay;
select * from app_receive;


idcompany
company


1
APPLE

2
GOOGLE

3
MICROSOFT

4
STEAM

5
AMAZON

6
LG




id
company
dueday
valuep


1
APPLE
2022-10-03
200.00

2
APPLE
2022-10-04
600.00

3
GOOGLE
2022-10-04
600.00

4
MICROSOFT
2022-10-04
500.00

5
MICROSOFT
2022-10-04
60.00

6
APPLE
2022-10-04
100.00




idconta
company
issuedate
valuer


104
MICROSOFT
2022-10-03
70000.00

106
STEAM
2022-10-03
15000.00

107
STEAM
2022-10-03
42000.00

108
AMAZON
2022-10-03
46000.00

109
LG
2022-10-03
3200.00


SELECT o.company, value_pay, value_receive 
FROM app_company AS o 
LEFT JOIN  (select sum(valuep) as value_pay,company from app_pay 
  where date(dueday) BETWEEN '2022-10-01' AND '2022-10-30' group by company) 
  AS n ON o.company=n.company 
LEFT JOIN  (SELECT SUM(valuer)  AS value_receive,  
  SUM(valuer) * 100.0 / SUM(SUM(valuer)) OVER () AS Percentage, 
  company from app_receive
 where date(issuedate) BETWEEN '2022-10-01' AND '2022-10-30'group by company)
  AS r ON o.company=r.company order by o.company asc;


company
value_pay
value_receive


AMAZON
null
46000.00

APPLE
900.00
null

GOOGLE
600.00
null

LG
null
3200.00

MICROSOFT
560.00
70000.00

STEAM
null
57000.00

id	company	dueday	valuep
1	APPLE	2022-10-03	200.00
2	APPLE	2022-10-04	600.00
3	GOOGLE	2022-10-04	600.00
4	MICROSOFT	2022-10-04	500.00
5	MICROSOFT	2022-10-04	60.00
6	APPLE	2022-10-04	100.00

idconta	company	issuedate	valuer
104	MICROSOFT	2022-10-03	70000.00
106	STEAM	2022-10-03	15000.00
107	STEAM	2022-10-03	42000.00
108	AMAZON	2022-10-03	46000.00
109	LG	2022-10-03	3200.00

company	value_pay	value_receive
AMAZON	null	46000.00
APPLE	900.00	null
GOOGLE	600.00	null
LG	null	3200.00
MICROSOFT	560.00	70000.00
STEAM	null	57000.00