select sum(sex="女") as a1,sum(sex="男") as a2 from tb_teacher
注:使用count条件不生效
---------------------------------------------------------------------------------------------------------------------------
tb_teacher表
select sum(sex="女") as a1,sum(sex="男") as a2 from tb_teacher
注:使用count条件不生效
---------------------------------------------------------------------------------------------------------------------------
tb_teacher表