JOINING PROBLEM

[Samwel Muro]

Please assist... I have the following table
Table: person
CREATE TABLE `person` (
`region` varchar(20) collate latin1_general_ci default NULL,
`name` varchar(20) collate latin1_general_ci default NULL,
`gender` char(2) collate latin1_general_ci default NULL,
);

insert into person (’UK’,'Steve’,'m’);
insert into person (’UK’,'Marie’,'f’);
insert into person (’UK’,'Rob’,'m’);
insert into person (’US’,'Bob’,'m’);
insert into person (’US’,'Michele’,'f’);
insert into person (’NL’,'Jim’,'m’);

Now i want to issue a query which will display in one row the number of male and female per region
That should be

Region|M_Count|F_Count
UK|2|1
US|1|1
NL|1|0

Please advice