CREATE TABLE player (School_ID VARCHAR2)
CREATE TABLE school (Location VARCHAR2, School_ID VARCHAR2)

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