题解 | #存在绩点大于该校平均绩点时的学生信息#
存在绩点大于该校平均绩点时的学生信息
https://www.nowcoder.com/practice/860fb125c6ac49b080766040f3bd902f
#该校的平均绩点 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;
不建议写那么大，可以从小出发更容易