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

#求每个学校的平均绩点
#select university,avg(gpa) from user_profile group by university;
#select a.device_id,a.university,a.gpa,b.av
#from user_profile a
#join (select university,avg(gpa) av from user_profile group by university)
#b on a.university=b.university ;

select c.device_id,c.university
from (select a.device_id,a.university,a.gpa,b.av
from user_profile a
join (select university,avg(gpa) av from user_profile group by university)
b on a.university=b.university )c
where c.gpa>c.av and c.av>3.6 order by c.device_id desc;