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

Compare the smallest enrollment of schools in each state using a bar chart, and I want to display by the X-axis in asc.
SELECT cName, MIN(enr) FROM College GROUP BY state ORDER BY cName
SELECT "cName", MIN("enr") FROM "College" GROUP BY "state" ORDER BY "cName"