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

Show the residences that have at least two players.
SELECT residence FROM player GROUP BY residence HAVING COUNT(*) >= 2
SELECT "residence" FROM "player" GROUP BY "residence" HAVING COUNT(*) >= 2