select a.device_id, a.university,a.gpa from
(select *,row_number()over(partition by university order by gpa asc) as ranking
from user_profile)a
where ranking =1

注意partition by分组后，取排名为1时，不用再加group by