Which of those residences have both male and female players?
SELECT Residence FROM player where gender  =  "M" intersect SELECT Residence FROM player where gender  =  "F"
residences with both male and female players require checking for existence of players of both genders within the same residence;