MySQL 5.7

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

create table cricket_table  (player varchar(50), score int, dateby date);
create table football_table  (player varchar(50), score int, dateby date);
 
insert into cricket_table values ('Sohail',32, '2020-01-02');
insert into cricket_table values ('Saleem',65, '2020-01-02');
insert into cricket_table values ('Hamid',76, '2020-01-02');
 
insert into football_table values ('Sohail',1, '2020-01-02');
insert into football_table values ('Saleem',2, '2020-01-02');
insert into football_table values ('Hamid',3, '2020-01-02');
 
insert into cricket_table values ('Sohail',33, '2020-05-02');
insert into cricket_table values ('Saleem',44, '2020-05-02');
insert into cricket_table values ('Hamid',22, '2020-05-02');
 
insert into football_table values ('Sohail',6, '2020-05-02');
insert into football_table values ('Saleem',7, '2020-05-02');
insert into football_table values ('Hamid',8, '2020-05-02');
SELECT * FROM cricket_table


player
score
dateby


Sohail
32
2020-01-02

Saleem
65
2020-01-02

Hamid
76
2020-01-02

Sohail
33
2020-05-02

Saleem
44
2020-05-02

Hamid
22
2020-05-02


SELECT * FROM football_table


player
score
dateby


Sohail
1
2020-01-02

Saleem
2
2020-01-02

Hamid
3
2020-01-02

Sohail
6
2020-05-02

Saleem
7
2020-05-02

Hamid
8
2020-05-02


SELECT z.dates,
       COALESCE(a.allscore, 0) AS cricket_score,
       COALESCE(b.allscore, 0) AS football_score
FROM (
  SELECT dateby AS dates FROM cricket_table
  UNION
  SELECT dateby FROM football_table
) AS z
LEFT JOIN (SELECT dateby AS dates, SUM(score) AS allscore 
           FROM cricket_table
           WHERE dateby BETWEEN '2020-01-01' AND '2020-05-03'
           GROUP BY dates
           ) a USING (dates)
LEFT JOIN (SELECT dateby AS dates, SUM(score) AS allscore 
           FROM football_table
           WHERE dateby BETWEEN '2020-01-01' AND '2020-05-03'
           GROUP BY dates
           ) b USING (dates)


dates
cricket_score
football_score


2020-01-02
173
6

2020-05-02
99
21

player	score	dateby
Sohail	32	2020-01-02
Saleem	65	2020-01-02
Hamid	76	2020-01-02
Sohail	33	2020-05-02
Saleem	44	2020-05-02
Hamid	22	2020-05-02