统计用户表(user)中,男女(gender: M:男 F:女)的人数
select count(when gender='M' then 'M' end ) asmaleCount, count(when gender='F' then 'F' end) as femaleCount from user
统计用户表(user)中,男女(gender: M:男 F:女)的人数
select count(when gender='M' then 'M' end ) asmaleCount, count(when gender='F' then 'F' end) as femaleCount from user