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 primary conference of the school that has the lowest acc percent score in the competition?
assistant
SELECT t1.Primary_conference FROM university AS t1 JOIN basketball_match AS t2 ON t1.school_id = t2.school_id ORDER BY t2.acc_percent LIMIT 1
human
Show the enrollment and primary_conference of the oldest college.
assistant
SELECT enrollment , primary_conference FROM university ORDER BY founded LIMIT 1
human
Find the founded year of the newest non public school.
assistant
SELECT founded FROM university WHERE affiliation != 'Public' ORDER BY founded DESC LIMIT 1
human
Find the location and all games score of the school that has Clemson as its team name.
assistant
SELECT t2.All_Games , t1.location FROM university AS t1 JOIN basketball_match AS t2 ON t1.school_id = t2.school_id WHERE team_name = 'Clemson'
human
List all schools and their nicknames in the order of founded year.
assistant
SELECT school , nickname FROM university ORDER BY founded
human
Return the name of the team and the acc during the regular season for the school that was founded the earliest.
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 ;