题解 | #每个学校的平均年龄和平均绩点及整体情况#

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