select
count() ,
sum(case when b.stu_gender=1 then 1 else 0 end )male,
sum(case when b.stu_gender=2 then 1 else 0 end )female,
sum(case when b.stu_gender=1 then 1 else 0 end )/count()malerate,
sum(case when b.stu_gender=2 then 1 else 0 end )/count(*)femalerate
from
t_class a
inner join t_student b on b.cls_id=a.cls_id
where
a.cls_name=‘会计1201’
如何计算男女比例利用mysql数据库
最新推荐文章于 2022-07-13 11:33:25 发布