SELECT Residence FROM player WHERE gender  =  "M" INTERSECT SELECT Residence FROM player WHERE gender  =  "F"
Show the residences that have both a player of gender "M" and a player of gender "F".
SELECT Residence FROM player WHERE gender = `` M '' INTERSECT SELECT Residence FROM player WHERE gender = `` F ''
select residence from player where gender = value intersect select residence from player where gender = value
Show the residences that have both a player of gender `` M '' and a player of gender `` F '' .