How many female players are there?
select count(*) from player where gender = 'F'
What about male players?
select count(*) from player where gender = 'M'
What are the residences of them?
select residence from player where gender = 'M'
Which residences have both female and male players?
select residence from player where gender = "M" intersect select residence from player where gender = "F"