counting each male and female sum for each country

royanders · #1 (**permalink**) 10-14-04, 09:58

Hi, I have a table like this:

'statistic' table:

country | gender|
------------------
usa | male |
uk | female |
usa | male |
usa |female |
china | male |
china | female |

how can i make a query that have output like this:

country | male | female |
--------------------------
usa | 2 | 1 |
uk | 0 | 1 |
china | 1 | 1 |

thanks in advance !

sanders

guelphdad · #2 (**permalink**) 10-14-04, 14:16

Code:

select country,
sum(case when gender = 'm' then 1 else 0 end) as male,
sum(case when gender = 'f' then 1 else 0 end) as female,
from yourtable
group by country

should do what you want.

Internet Services

Web Development

Digital Marketing

Consumer Tech