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

What is the name of the school that has the smallest enrollment in each state?, could you rank in desc by the Y-axis?
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 NULLS LAST