MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


8.0.30


create table data(date date, name varchar(100), certificates varchar(100));

insert into data values (date '2021-02-01', 'Jason', 'A');
insert into data values (date '2021-02-01', 'Jason', 'B');
insert into data values (date '2021-02-01', 'Jason', 'C');

insert into data values (date '2021-02-01', 'Nisha', null);
insert into data values (date '2021-02-01', 'Nisha', 'A');
insert into data values (date '2021-02-01', 'Nisha', 'B');
insert into data values (date '2021-02-01', 'Nisha', 'C');
insert into data values (date '2021-02-01', 'Nisha', 'D');

insert into data values (date '2021-02-01', 'Zaid', 'A');
insert into data values (date '2021-02-01', 'Zaid', 'B');
insert into data values (date '2021-02-01', 'Zaid', 'C');
insert into data values (date '2021-02-01', 'Zaid', 'D');
insert into data values (date '2021-02-01', 'Zaid', 'E');

insert into data values (date '2021-03-25', 'Aniket', 'A');
insert into data values (date '2021-03-25', 'Aniket', 'B');
insert into data values (date '2021-03-25', 'Aniket', 'C');
insert into data values (date '2021-03-25', 'Aniket', 'D');

insert into data values (date '2021-03-25', 'Anish', 'A');
insert into data values (date '2021-03-25', 'Anish', 'B');

insert into data values (date '2021-03-25', 'Nadia', null);

insert into data values (date '2021-05-06', 'Aadil', 'A');
insert into data values (date '2021-05-06', 'Aadil', 'B');
insert into data values (date '2021-05-06', 'Aadil', 'C');
insert into data values (date '2021-05-06', 'Aadil', 'D');
insert into data values (date '2021-05-06', 'Aadil', 'E');
insert into data values (date '2021-05-06', 'Aadil', 'F');
insert into data values (date '2021-05-06', 'Aadil', 'G');

insert into data values (date '2021-05-06', 'Ashish', 'A');

insert into data values (date '2021-05-06', 'Rahil', 'A');
insert into data values (date '2021-05-06', 'Rahil', 'B');
insert into data values (date '2021-05-06', 'Rahil', 'C');
insert into data values (date '2021-05-06', 'Rahil', 'D');
insert into data values (date '2021-05-06', 'Rahil', 'E');
insert into data values (date '2021-05-06', 'Rahil', 'F');
insert into data values (date '2021-05-06', 'Rahil', 'G');
insert into data values (date '2021-05-06', 'Rahil', 'H');
insert into data values (date '2021-05-06', 'Rahil', 'I');
SELECT date, name, certificates
FROM
(
  SELECT 
    date, name, COUNT(Certificates) AS certificates,
    ROW_NUMBER() OVER (PARTITION BY date ORDER BY name) AS rn
  FROM data
  GROUP BY date, name
) numbered
WHERE rn = 1
ORDER BY date;


date
name
certificates


2021-02-01
Jason
3

2021-03-25
Aniket
4

2021-05-06
Aadil
7