题目如下:
题解:
select "总体" as university,round(avg(age),3) as avg_age, round(avg(gpa),3) as avg_gpa
from user_profile
union all
select university, round(avg(age),3) as avg_age, round(avg(gpa),3) as avg_gpa
from user_profile
group by university
题目如下:
题解:
select "总体" as university,round(avg(age),3) as avg_age, round(avg(gpa),3) as avg_gpa
from user_profile
union all
select university, round(avg(age),3) as avg_age, round(avg(gpa),3) as avg_gpa
from user_profile
group by university