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

select
    up2.device_id,
    up2.university,
    up2.gpa
from
    user_profile as up2
    inner join (
        select
            device_id,
            university,
            min(gpa) over (
                partition by
                    university
                order by
                    university
            ) as gpa
        from
            user_profile
    ) as up1 on up1.device_id = up2.device_id
    and up1.university = up2.university
    and up1.gpa = up2.gpa
order by up2.university