题解 | #找出每个学校GPA最低的同学#

SELECT device_id,t1.university,t1.gpa
 from user_profile t1
        inner join 
        (select min(gpa) as lowest_gpa,t2.university
        from user_profile t2
        group by t2.university 
        ) t3
        on t1.university=t3.university and t1.gpa=t3.lowest_gpa
 order by t1.university ASC