select
count(gender) as male_num,
round (avg(gpa), 1) as avg_gpa
from user_profile
where gender = "male"
注意缩进,count函数与括号之间不要留空格

select
count(gender) as male_num,
round (avg(gpa), 1) as avg_gpa
from user_profile
where gender = "male"
注意缩进,count函数与括号之间不要留空格