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

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;