human
Schema:
basketball_match (Team_ID, School_ID, Team_Name, ACC_Regular_Season, ACC_Percent, ACC_Home, ACC_Road, All_Games, All_Games_Percent, All_Home, All_Road, All_Neutral)
university (School_ID, School, Location, Founded, Affiliation, Enrollment, Nickname, Primary_conference)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the different affiliation types of these schools?
assistant
SELECT DISTINCT affiliation FROM university;
human
Which universities have over a 20000 enrollment size?
assistant
SELECT School FROM university WHERE enrollment > 20000;
human
Can you also list their affiliation type?
assistant
SELECT School , affiliation FROM university WHERE enrollment > 20000;
human
How many are there in each affiliation group?
assistant
SELECT COUNT( * ) , affiliation FROM university WHERE enrollment > 20000 GROUP BY affiliation ;