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 is the total and minimum enrollment of all schools?
assistant
SELECT sum(enrollment) , min(enrollment) FROM university
human
Find the total student enrollment for different affiliation type schools.
assistant
SELECT sum(enrollment) , affiliation FROM university GROUP BY affiliation
human
When was the school with the largest enrollment founded?
assistant
SELECT founded FROM university ORDER BY enrollment DESC LIMIT 1
human
Find the schools that were either founded after 1850 or public.
assistant
SELECT school FROM university WHERE founded > 1850 OR affiliation = 'Public'
human
What are the average enrollment size of the universities that are founded before 1850?
assistant
SELECT avg(enrollment) FROM university WHERE founded < 1850
human
What are the different affiliations, and what is the total enrollment of schools founded after 1850 for each enrollment type?
assistant
SELECT SUM( Enrollment ) , affiliation FROM university WHERE founded > 1850 GROUP BY affiliation ;