题解 | #找出每个学校GPA最低的同学#
找出每个学校GPA最低的同学
https://www.nowcoder.com/practice/90778f5ab7d64d35a40dc1095ff79065
SELECT up1.device_id, up2.university, up2.gpa
FROM user_profile AS up1
INNER JOIN (
SELECT university, MIN(gpa) AS gpa
FROM user_profile
GROUP BY university
) AS up2 ON up1.university = up2.university AND up1.gpa = up2.gpa
ORDER BY up2.university;
