题解 | #找出每个学校GPA最低的同学#
找出每个学校GPA最低的同学
https://www.nowcoder.com/practice/90778f5ab7d64d35a40dc1095ff79065
select up.device_id,up.university,gpa from user_profile up left join ( select university ,min(gpa) min_gpa from user_profile group by university) t on up.university = t.university where up.gpa = t.min_gpa order by up.university
先查询出每个学校的最低的gpa，然后与原表通过university字段做关联，最后筛选出gpa等于最低gpa的数据
