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;

#这个有点难啊