select
t.device_id,
t.university,
t.gpa
from
(select *,dense_rank()over(partition by university order by gpa asc) as m
from user_profile
) as t
WHERE
t.m=1

窗口函数一目了然