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

count 统计数量