SQL count how many male and femal in the same type

Question

Above is my participants table and my problem is I want to count how many male and female are the same type of participant. Below is the code I have that count how many participant per type.

SELECT type_parti, COUNT(1) FROM tbl_participants GROUP BY type_parti

score 1 · Accepted Answer · answered Dec 26 '16 at 08:25

1

Use a conditional sum

SELECT type_parti, 
       sum(sex = 'm') as males,
       sum(sex = 'f') as females 
FROM tbl_participants 
GROUP BY type_parti

answered Dec 26 '16 at 08:25

juergen d

201,996
37
293
362

Yes this works great! Thanks – propaganja Dec 26 '16 at 08:50

SQL count how many male and femal in the same type

1 Answers1