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 information is there on colleges in Florida?
assistant
SELECT * FROM college WHERE state = 'FL';
human
What is their maximum enrollment size?
assistant
SELECT MAX( enr ) FROM college WHERE state = 'FL';
human
What is the name of every college that is larger than that?
assistant
SELECT cName FROM college WHERE enr > ( SELECT MAX( enr ) FROM college WHERE state = "FL" ) ;