题解 | #存在绩点大于该校平均绩点时的学生信息#
存在绩点大于该校平均绩点时的学生信息
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
投递华为等公司8个岗位 >
查看11道真题和解析
