SQL17 计算男生人数以及平均GPA

https://www.nowcoder.com/practice/7d9a7b2d6b4241dbb5e5066d7549ca01?tpId=199&tags=&title=&difficulty=0&judgeStatus=0&rp=0

SELECT 
    COUNT(gender) as male_num,
    ROUND(AVG(gpa),1) as avg_gpa
FROM user_profile WHERE gender = 'male';