CREATE TABLE club (club_id NUMBER, club_name CLOB, region CLOB, start_year NUMBER)
CREATE TABLE coach (coach_id NUMBER, coach_name CLOB, gender CLOB, club_id NUMBER, rank NUMBER)
CREATE TABLE player (player_id NUMBER, sponsor_name CLOB, player_name CLOB, gender CLOB, residence CLOB, occupation CLOB, votes NUMBER, rank CLOB)
CREATE TABLE player_coach (player_id NUMBER, coach_id NUMBER, starting_year NUMBER)
CREATE TABLE match_result (rank NUMBER, club_id NUMBER, gold NUMBER, big_silver NUMBER, small_silver NUMBER, bronze NUMBER, points NUMBER)

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 "M" = "gender" INTERSECT SELECT "residence" FROM "player" WHERE "F" = "gender"