human
Schema:
College (cName, state, enr)
Player (pID, pName, yCard, HS)
Tryout (pID, cName, pPos, decision)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the average number of students per college?
assistant
SELECT AVG ( enr ) FROM college;
human
What states have colleges that are smaller than that?
assistant
SELECT DISTINCT state FROM college WHERE enr < ( SELECT AVG ( enr ) FROM college ) ;