mysql - 总结初始列 mysql

Question

我创建了一个这样的查询

 "select count(if(gender="male",1,null)) as malecount,
  count(if(gender="female",1,null)) as femalecount from biodata"

这是工作，我想总结一下这个计数:

 "select count(if(gender="male",1,null)) as malecount,
  count(if(gender="female",1,null)) as femalecount, male+female as sumgender 
  from biodata"

当然，当我在 if 语句中设置许多条件时，该查询会有所帮助

请帮我解决这个问题...

Answer 1

这样写可以解决问题

select malecount+femalecount as sumcount from  (select
count(if(gender="male",1,null)) as malecount,  
 count(if(gender="female",1,null)) as femalecount   from biodata) as
 query