题解 | #存在绩点大于该校平均绩点时的学生信息#
存在绩点大于该校平均绩点时的学生信息
https://www.nowcoder.com/practice/860fb125c6ac49b080766040f3bd902f
select u1.device_id, u1.university from user_profile as u1 inner join ( select university, avg(gpa) as avg_gpa from user_profile group by university having avg(gpa) > 3.6 ) as u2 on u1.university = u2.university where u1.gpa > u2.avg_gpa order by u1.device_id desc;
投递哔哩哔哩等公司10个岗位