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
hello there! Can you please provide me with a list of all college names?
assistant
SELECT cName FROM college;
human
Thank you for that! Can you show me the names of all colleges with an enrollment value that is greater than the total enrollment of all of the colleges in the state of FL?
assistant
SELECT cName FROM college;
human
Excellent! Can you update this list to show me the enrollment quantity associated with each college?
assistant
SELECT cName , enr FROM college WHERE enr > ( SELECT MAX( enr ) FROM college WHERE state = "FL" ) ;