create table Stu_Table(Stu_Id INT(2), Stu_Name varchar(15), 
Stu_Class  varchar(10),sub_id INT(2),marks INT(3));
 
insert into Stu_Table values(1,'Komal',10,1,45);
insert into Stu_Table values(2,'Ajay',10,1,56);
insert into Stu_Table values(3,'Rakesh',10,1,67);
 
insert into Stu_Table values(1,'Komal',10,2,47);
insert into Stu_Table values(2,'Ajay',10,2,53);
insert into Stu_Table values(3,'Rakesh',10,2,57);
 
insert into Stu_Table values(1,'Komal',10,3,45);
insert into Stu_Table values(2,'Ajay',10,3,45);
insert into Stu_Table values(3,'Rakesh',10,3,67);
 
insert into Stu_Table values(1,'Komal',10,4,65);
insert into Stu_Table values(2,'Ajay',10,4,56);
insert into Stu_Table values(3,'Rakesh',10,4,37);
 
insert into Stu_Table values(1,'Komal',10,5,65);
insert into Stu_Table values(2,'Ajay',10,5,46);
insert into Stu_Table values(3,'Rakesh',10,5,63);
 

Y3JlYXRlIHRhYmxlIFN0dV9UYWJsZShTdHVfSWQgSU5UKDIpLCBTdHVfTmFtZSB2YXJjaGFyKDE1KSwgClN0dV9DbGFzcyAgdmFyY2hhcigxMCksc3ViX2lkIElOVCgyKSxtYXJrcyBJTlQoMykpOwogCmluc2VydCBpbnRvIFN0dV9UYWJsZSB2YWx1ZXMoMSwnS29tYWwnLDEwLDEsNDUpOwppbnNlcnQgaW50byBTdHVfVGFibGUgdmFsdWVzKDIsJ0FqYXknLDEwLDEsNTYpOwppbnNlcnQgaW50byBTdHVfVGFibGUgdmFsdWVzKDMsJ1Jha2VzaCcsMTAsMSw2Nyk7CiAKaW5zZXJ0IGludG8gU3R1X1RhYmxlIHZhbHVlcygxLCdLb21hbCcsMTAsMiw0Nyk7Cmluc2VydCBpbnRvIFN0dV9UYWJsZSB2YWx1ZXMoMiwnQWpheScsMTAsMiw1Myk7Cmluc2VydCBpbnRvIFN0dV9UYWJsZSB2YWx1ZXMoMywnUmFrZXNoJywxMCwyLDU3KTsKIAppbnNlcnQgaW50byBTdHVfVGFibGUgdmFsdWVzKDEsJ0tvbWFsJywxMCwzLDQ1KTsKaW5zZXJ0IGludG8gU3R1X1RhYmxlIHZhbHVlcygyLCdBamF5JywxMCwzLDQ1KTsKaW5zZXJ0IGludG8gU3R1X1RhYmxlIHZhbHVlcygzLCdSYWtlc2gnLDEwLDMsNjcpOwogCmluc2VydCBpbnRvIFN0dV9UYWJsZSB2YWx1ZXMoMSwnS29tYWwnLDEwLDQsNjUpOwppbnNlcnQgaW50byBTdHVfVGFibGUgdmFsdWVzKDIsJ0FqYXknLDEwLDQsNTYpOwppbnNlcnQgaW50byBTdHVfVGFibGUgdmFsdWVzKDMsJ1Jha2VzaCcsMTAsNCwzNyk7CiAKaW5zZXJ0IGludG8gU3R1X1RhYmxlIHZhbHVlcygxLCdLb21hbCcsMTAsNSw2NSk7Cmluc2VydCBpbnRvIFN0dV9UYWJsZSB2YWx1ZXMoMiwnQWpheScsMTAsNSw0Nik7Cmluc2VydCBpbnRvIFN0dV9UYWJsZSB2YWx1ZXMoMywnUmFrZXNoJywxMCw1LDYzKTsK

U0VMRUNUICogRlJPTSAoc2VsZWN0IFN0dV9JZCxtaW4obWFya3MpIGFzIG1pbmksc3VtKG1hcmtzKSBhcyBwZXIKZnJvbSBzdHVfdGFibGUgZ3JvdXAgYnkgc3R1X2lkLG1hcmtzKSBvcmRlciBieSBtaW5pOwoKU2VsZWN0ICcgJyA7CgpzZWxlY3QgKiBGcm9tIChTRUxFQ1QgKiBGUk9NIChzZWxlY3QgU3R1X0lkLG1pbihtYXJrcykgYXMgbWluaSxzdW0obWFya3MpIGFzIHBlcgpmcm9tIHN0dV90YWJsZSBncm91cCBieSBzdHVfaWQsbWFya3MpIGdyb3VwIGJ5IG1pbmkpOw==

SELECT * FROM (select Stu_Id,min(marks) as mini,sum(marks) as per
from stu_table group by stu_id,marks) order by mini;

Select ' ' ;

select * From (SELECT * FROM (select Stu_Id,min(marks) as mini,sum(marks) as per
from stu_table group by stu_id,marks) group by mini);