Show me the school details.
select * from school_details;
What's each school's color?
select colors from school_details;
List the location and nickname of each school.
select t1.location, t2.nickname from school as t1 join school_details as t2 on t1.school_id = t2.school_id;