CREATE TABLE school_details (school_id NUMBER, nickname CLOB, colors CLOB, league CLOB, class CLOB, division CLOB)
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 player (player_id NUMBER, player CLOB, team CLOB, age NUMBER, position CLOB, school_id NUMBER)
CREATE TABLE school_performance (school_id NUMBER, school_year CLOB, class_a CLOB, class_aa CLOB)

For each player, show the team and the location of school they belong to.
SELECT T1.team, T2.location FROM player AS T1 JOIN school AS T2 ON T1.school_id = T2.school_id
SELECT "T1"."team", "T2"."location" FROM "player" "T1" JOIN "school" "T2" ON "T1"."school_id" = "T2"."school_id"