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
list the name of college in az?
assistant
SELECT cName FROM College WHERE state = 'AZ';
human
list the name of the colleges whose enrollment is lesser than 18000 sorted by the college's name?
assistant
SELECT cName FROM College WHERE enr > 18000 ORDER BY cName;
human
which college enrollment is 22000?
assistant
SELECT cName FROM College WHERE enr = 22000;
human
list the name of the colleges whose enrollment is greater than 12000 sorted by the college's name and state?
assistant
SELECT cName FROM College WHERE enr > 12000 ORDER BY cName , state ;