题解 | #存在绩点大于该校平均绩点时的学生信息#
存在绩点大于该校平均绩点时的学生信息
https://www.nowcoder.com/practice/860fb125c6ac49b080766040f3bd902f
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
