human
Schema:
school (School_ID, School, Location, Enrollment, Founded, Denomination, Boys_or_Girls, Day_or_Boarding, Year_Entered_Competition, School_Colors)
school_details (School_ID, Nickname, Colors, League, Class, Division)
school_performance (School_Id, School_Year, Class_A, Class_AA)
player (Player_ID, Player, Team, Age, Position, School_ID)
Please answer with SQL.
assistant
Sure, I understand.
human
Show me the school names in division 1.
assistant
SELECT School FROM school_details AS T1 JOIN school AS T2 ON T1.school_id = T2.school_id WHERE T1.Division = 'Division 1' ;
human
How about those not in division 1?
assistant
SELECT School FROM school_details AS T1 JOIN school AS T2 ON T1.school_id = T2.school_id WHERE T1.Division != "Division 1" ;