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

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" AS "T1" JOIN "school" AS "T2" ON "T1"."School_ID" = "T2"."School_ID"