Show me the school names in division 1.
select school from school_details as t1 join school as t2 on t1.school_id = t2.school_id where t1.division = "Division 1";
How about those not in division 1?
select school from school_details as t1 join school as t2 on t1.school_id = t2.school_id where t1.division != "Division 1";
List their nicknames.
select nickname from school_details where division != "Division 1";