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

select
    device_id,
    university,
    gpa
from
    (
        select
            device_id,
            university,
            gpa,
            rank() over (
                partition by
                    university
                order by
                    gpa
            ) rk
        from
            user_profile
    ) a
where
    a.rk = 1;