Schema: CREATE TABLE player (Residence VARCHAR, gender VARCHAR)
Question: Show the residences that have both a player of gender "M" and a player of gender "F".
SQL: SELECT Residence FROM player WHERE gender = "M" INTERSECT SELECT Residence FROM player WHERE gender = "F"