sql sum同时统计一个字段两种情况的总数

 select sum(sex="女"） as a1，sum(sex="男") as a2 from tb_teacher

注：使用count条件不生效

---------------------------------------------------------------------------------------------------------------------------

tb_teacher表