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