Showing 1 bookmark (both private and shared)
Collapse
Expand
Requery
Edit
Delete
Database
: voter_management
Total Male Female
SELECT COUNT(*) AS total_voters, SUM(CASE WHEN UPPER(TRIM(COALESCE(gender, ''))) IN ('M', 'MALE') THEN 1 ELSE 0 END) AS male_count, SUM(CASE WHEN UPPER(TRIM(COALESCE(gender, ''))) IN ('F', 'FEMALE') THEN 1 ELSE 0 END) AS female_count, SUM(CASE WHEN UPPER(TRIM(COALESCE(gender, ''))) NOT IN ('M', 'MALE', 'F', 'FEMALE') THEN 1 ELSE 0 END) AS others_count FROM voters;