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

select u.device_id as device_id,u.university as university, u.gpa as gpa
from (select * ,row_number() over (partition by ub.university order by ub.gpa asc) as rn from user_profile ub ) u
where u.rn = 1
order by u.university;