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