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