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 Lebanon Valley College?
assistant
SELECT Primary_conference FROM university WHERE School = 'Lebanon Valley College';
human
What is the nickname of University of Rhode Island?
assistant
SELECT Nickname FROM university WHERE School = 'University of Rhode Island';
human
What is the location of Fightin' Blue Hens?
assistant
SELECT location FROM university WHERE Nickname = "Fightin Blue Hens" ;