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

select
b.device_id
,a.*
from
(
    select
    university
    ,min(gpa) as gpa
    from user_profile
    group by 1
) a
left join
(
    select
    *
    ,row_number()over(partition by university order by gpa) rk
    from user_profile
)b
on a.university = b.university
and a.gpa = b.gpa
where rk = 1
order by 2