题解 | #每个学校的平均年龄和平均绩点及整体情况#
每个学校的平均年龄和平均绩点及整体情况
https://www.nowcoder.com/practice/d686ac1d09d94441be91475843797d2d
select '总体' as university,round(AVG(age),3) avg_age,round(avg(gpa),3) avg_gpa from user_profile union select university,round(AVG(age),3),round(avg(gpa),3) from user_profile group by university
查看8道真题和解析