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():默认四舍五入，保留两位小数