题解 | #找出每个学校GPA最低的同学#
找出每个学校GPA最低的同学
http://www.nowcoder.com/practice/90778f5ab7d64d35a40dc1095ff79065
SELECT device_id,temp.u,temp.m FROM user_profile up, (SELECT university u,MIN(gpa) m FROM user_profile GROUP BY university ORDER BY university) temp WHERE up.university=temp.u AND up.gpa=temp.m ORDER BY up.university;
#这个有点难啊