sql question

–create table aryan (name varchar(30),branch varchar(30),cgpa float);
–insert into aryan values(‘ghi’,’MEC’,7);
select *from aryan;
select branch,min(cgpa) from aryan group by branch;

question1:

show the name and course code of the student having minimum cgpa in each branch.
ans:

select  name,branch from aryan where (branch,cgpa)=any(select branch,min(cgpa) from aryan group by branch);