CREATE TABLE College (cName VARCHAR2, state VARCHAR2, enr NUMBER)
CREATE TABLE Tryout (pID NUMBER, cName VARCHAR2, pPos VARCHAR2, decision VARCHAR2)
CREATE TABLE Player (pID NUMBER, pName VARCHAR2, yCard VARCHAR2, HS NUMBER)

Show the smallest enrollment of each state, and could you rank in ascending by the total number?
SELECT state, MIN(enr) FROM College GROUP BY state ORDER BY MIN(enr)
SELECT "state", MIN("enr") FROM "College" GROUP BY "state" ORDER BY MIN("enr")