牛客sql基础强化之存在绩点大于该校平均成绩

题目如下：

代码如下：

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