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 team name and acc regular season score of the school that was founded for the longest time?
assistant
SELECT t2.team_name , t2.ACC_Regular_Season FROM university AS t1 JOIN basketball_match AS t2 ON t1.school_id = t2.school_id ORDER BY t1.founded LIMIT 1
human
List all schools and their nicknames in the order of founded year.
assistant
SELECT school , nickname FROM university ORDER BY founded
human
What is the total and minimum enrollment of all schools?
assistant
SELECT sum(enrollment) , min(enrollment) FROM university
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 is the maximum enrollment across all schools?
assistant
SELECT max(Enrollment) FROM university
human
When was the school with the largest enrollment founded?
assistant
SELECT founded FROM university ORDER BY enrollment DESC LIMIT 1 ;