题解 | 计算男生人数以及平均GPA
计算男生人数以及平均GPA
https://www.nowcoder.com/practice/7d9a7b2d6b4241dbb5e5066d7549ca01
select count(gender) as male_num ,avg(gpa) as avg_gpa from user_profile where gender = 'male' ; 和 select count(gender) as male_num ,round(avg(gpa),1) as avg_gpa from user_profile where gender = 'male' ; 其中：round(avg(gpa),1)表示对平均数取一个小数位