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

with cte as (
select device_id,university,gpa,
                            avg(gpa)over(partition by university) as avg_gpa
from user_profile )
select device_id,university
from cte 
where gpa>avg_gpa and avg_gpa>3.6
order by device_id desc