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
Can you list all the colleges and their enrollments?
assistant
SELECT cName , enr FROM college;
human
Which college has the largest enrollment?
assistant
SELECT cname FROM college WHERE enr = ( SELECT MAX( enr ) FROM college );
human
Hmm, I also want to know which colleges have enrollments that are less than the largest size.
assistant
SELECT cname FROM college WHERE enr < ( SELECT MAX( enr ) FROM college ) ;