题解 | #找出每个学校GPA最低的同学#

select 
device_id ,
university,
gpa 
from user_profile u1
where gpa <=
 (select min(gpa) 
from user_profile u2
where u1.university=u2.university
group by university)
order by university