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

#该校的平均绩点 avg(gpa)>3.6

select device_id,university
from(
select device_id,
        university,
        gpa,
        avg(gpa) over(partition by university) as "school_avg_gpa"
from user_profile
)a
where gpa>school_avg_gpa and school_avg_gpa>3.6
order by device_id desc;