SELECT SUM(CASE WHEN Gender = 'male' THEN 1 ELSE 0 END) as Male_count,
SUM(CASE WHEN Gender = 'Female' THEN 1 ELSE 0 END) as Female_count
FROM some_unkNown_table
如nightfox79所述,如果您的默认排序规则区分大小写,则可能应转换文本以确保匹配。所以用这个
UPPER(GENDER) = 'MALE'
UPPER(GENDER) = 'FEMALE'
旁注:我认为您应该按照这种格式在Gender中使用tinyint列,如Damien所述。https://zh.wikipedia.org/wiki/ISO/IEC_5218