CREATE TABLE school_details (school_id NUMBER, nickname CLOB, colors CLOB, league CLOB, class CLOB, division CLOB)
CREATE TABLE player (player_id NUMBER, player CLOB, team CLOB, age NUMBER, position CLOB, school_id NUMBER)
CREATE TABLE school (school_id NUMBER, school CLOB, location CLOB, enrollment NUMBER, founded NUMBER, denomination CLOB, boys_or_girls CLOB, day_or_boarding CLOB, year_entered_competition NUMBER, school_colors CLOB)
CREATE TABLE school_performance (school_id NUMBER, school_year CLOB, class_a CLOB, class_aa CLOB)

Show the locations of schools that have more than 1 player.
SELECT T2.location FROM player AS T1 JOIN school AS T2 ON T1.school_id = T2.school_id GROUP BY T1.school_id HAVING COUNT(*) > 1
SELECT "T2"."location" FROM "player" "T1" JOIN "school" "T2" ON "T1"."school_id" = "T2"."school_id" GROUP BY "T1"."school_id" HAVING COUNT(*) > 1