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)

Return a bar graph for the name of the school that has the smallest enrollment in each state, and I want to rank by the Y-axis in desc.
SELECT cName, MIN(enr) FROM College GROUP BY state ORDER BY MIN(enr) DESC
SELECT "cName", MIN("enr") FROM "College" GROUP BY "state" ORDER BY MIN("enr") DESC