select device_id,university,gpa from(
select device_id,university,gpa,
row_number() over(partition by university order by gpa) as gpa_rank 
from user_profile ) a
where gpa_rank = 1;

运用子查询时一定要注意，给被查询的表取名