Execuse me

Since you did not understand i how given that data and more over i do not want to disclose my original data i have given that, if you insist then have a look

Create table Student(Studentid int,name varchar(50),maths int,science int,com int)

insert into Student values(1,'Allen',40,50,89)

insert into Student values(2,'John',70,90,89)

insert into Student values(1,'Nick',90,80,89)

Thank you