题解 | #计算男生人数以及平均GPA#

select count(device_id ) AS maie_num ,AVG(gpa) as avg_gpa
from user_profile
where gender='male'
group by gender