题解 | #找出每个学校GPA最低的同学#
找出每个学校GPA最低的同学
https://www.nowcoder.com/practice/90778f5ab7d64d35a40dc1095ff79065
select up.device_id,up.university,up.gpa from (select university,min(gpa) mingpa from user_profile group by university) sq1 join user_profile up on up.gpa = sq1.mingpa and up.university = sq1.university order by up.university;
select university,min(gpa) mingpa from user_profile group by university 这段找最小值和学校 然后将学校和最小值与原表连接然后排序