Show locations and nicknames of schools.
create table school (location varchar, school_id varchar, PRIMARY KEY (location)); create table school_details (nickname varchar, school_id varchar, PRIMARY KEY (nickname))
select t1.location, t2.nickname from school as t1 join school_details as t2 on t1.school_id = t2.school_id