CREATE TABLE school (Location VARCHAR2, School_ID VARCHAR2)
CREATE TABLE school_details (Nickname VARCHAR2, School_ID VARCHAR2)

Show locations and nicknames of schools.
SELECT T1.Location, T2.Nickname FROM school AS T1 JOIN school_details AS T2 ON T1.School_ID = T2.School_ID
SELECT "T1"."Location", "T2"."Nickname" FROM "school" "T1" JOIN "school_details" "T2" ON "T1"."School_ID" = "T2"."School_ID"