题解 | #存在绩点大于该校平均绩点时的学生信息#

select device_id,university 
from
(select gpa,device_id,university,avg(gpa) over(partition by university) avgg
 from user_profile
) t

where gpa>t.avgg and t.avgg>3.6
order by device_id desc