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 are the top 3 enrollment numbers among the schools?
assistant
SELECT enr FROM college ORDER BY enr DESC LIMIT 3;
human
Hmm, I want to know the states of the schools with the top 3 largest size.
assistant
SELECT state FROM college ORDER BY enr DESC LIMIT 3;
human
Can you tell me the names of the schools with the top 3 largest size?
assistant
SELECT cName FROM college ORDER BY enr DESC LIMIT 3 ;