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

-- 熟悉窗口函数的使用：row_number() over (partition by university order by gpa) as rn
select device_id, university, gpa
from (
    select *,
    row_number() over (partition by university order by gpa) as rn
    from user_profile
) as univ_min
where rn=1
order by university