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
本题思路,先找出学校-低分,再用where in 匹配(注意匹配一致性)