Show me the location of each school.
select location from school;
For each player, show the location of the school they belong to.
select t2.location from player as t1 join school as t2 on t1.school_id = t2.school_id;
Also provide, the team name.
select t1.team, t2.location from player as t1 join school as t2 on t1.school_id = t2.school_id;