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

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"