CREATE TABLE tryout (pid NUMBER, cname CLOB, ppos CLOB, decision CLOB)
CREATE TABLE player (pid NUMBER, pname CLOB, ycard CLOB, hs NUMBER)
CREATE TABLE college (cname CLOB, state CLOB, enr NUMBER)

What is the name of the school with smallest enrollment size per state?
SELECT cname, state, MIN(enr) FROM college GROUP BY state
SELECT "cname", "state", MIN("enr") FROM "college" GROUP BY "state"