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

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;

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