题解 | #存在绩点大于该校平均绩点时的学生信息#
存在绩点大于该校平均绩点时的学生信息
https://www.nowcoder.com/practice/860fb125c6ac49b080766040f3bd902f
select u.device_id,u.university
from user_profile u,(
select university,avg(gpa) as avg_gpa
from user_profile
group by university
having avg(gpa)>3.6
) as a
where a.avg_gpa<u.gpa and a.university=u.university
order by device_id desc;
