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

select
    a.device_id device_id,
    a.university university,
    a.gpa gpa
from
    user_profile a
    right join (
        select
            university,
            min(gpa) as gpa
        from
            user_profile
        group by
            university
    ) as b on a.university = b.university
    and a.gpa = b.gpa
order by
    a.university