select count(gender) as male_num,
round(avg(gpa),1) as avg_gpa
from user_profile
where gender = 'male';

1.男性
2.计数:count()
3.平均:avg()

1.别名
2.round():默认四舍五入,保留两位小数