题解 | #每个学校的平均年龄和平均绩点及整体情况#
每个学校的平均年龄和平均绩点及整体情况
https://www.nowcoder.com/practice/d686ac1d09d94441be91475843797d2d
select case when isnull(university) then '总体' else university end as 'university',
round(avg(age),3) as avg_age,
round(avg(gpa),3) as avg_gpa
from user_profile
group by university
with rollup
order by university
投递腾讯等公司10个岗位 >
