select device_id,university,gpa
from user_profile
where (university,gpa) in (select university,min(gpa) from user_profile group by university)
order by university
#说是对不上,所以需要子查询
#这里是用子查询来做的

子查询很重要