SELECT
COUNT(gender) as male_num,
ROUND(AVG(gpa),1) as avg_gpa
FROM user_profile WHERE gender = 'male';
相关文章
- 12-28SQL17 计算男生人数以及平均GPA
2021-12-28 01:28:06
SELECT
COUNT(gender) as male_num,
ROUND(AVG(gpa),1) as avg_gpa
FROM user_profile WHERE gender = 'male';
下一篇:安卓 自定义验证码输入框