题解 | #计算男生人数以及平均GPA#
1、as表头重命名 select count(gender) as male_num
2、计数:count函数
3、保留小数位数:round(列名,位数)
4、求平均数:avg函数
完整sql:
select count(gender) as male_num, round(avg(gpa),1) as avg_gpa
from user_profile where gender='male'
题解 | #计算男生人数以及平均GPA#
1、as表头重命名 select count(gender) as male_num
2、计数:count函数
3、保留小数位数:round(列名,位数)
4、求平均数:avg函数
完整sql:
select count(gender) as male_num, round(avg(gpa),1) as avg_gpa
from user_profile where gender='male'