MySQL 8.0

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

select version();


version()


8.0.26


create table students( date_ date, name varchar(250) , certificates_ int) ;

insert into students values (    '2021-02-01',         'Jason',             3    );
insert into students values (    '2021-02-01',         'Nisha',             4    );
insert into students values (    '2021-02-01',         'Zaid',             5    );
insert into students values (    ' 2021-03-25',         'Aniket',             4   );
insert into students values (    ' 2021-03-25',         'Anish',             2    );
insert into students values (    ' 2021-03-25',         'Nadia',             0    );
insert into students values (    '2021-05-06',         'Aadil',             7   );
insert into students values (    '2021-05-06',         'Ashish',             1   );
insert into students values (    '2021-05-06',         'Rahil',             9   );
















select * from students


date_
name
certificates_


2021-02-01
Jason
3

2021-02-01
Nisha
4

2021-02-01
Zaid
5

2021-03-25
Aniket
4

2021-03-25
Anish
2

2021-03-25
Nadia
0

2021-05-06
Aadil
7

2021-05-06
Ashish
1

2021-05-06
Rahil
9


WITH ranked_data AS (
SELECT
date_,
name,
certificates_,
row_number() OVER(PARTITION BY date_ order by name) as rank_
FROM 
  students
)
SELECT 
  date_,
  name,
  certificates_
FROM
  ranked_data
WHERE rank_ = 1


date_
name
certificates_


2021-02-01
Jason
3

2021-03-25
Aniket
4

2021-05-06
Aadil
7

date_	name	certificates_
2021-02-01	Jason	3
2021-02-01	Nisha	4
2021-02-01	Zaid	5
2021-03-25	Aniket	4
2021-03-25	Anish	2
2021-03-25	Nadia	0
2021-05-06	Aadil	7
2021-05-06	Ashish	1
2021-05-06	Rahil	9