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

Find the number of students who participate in the tryout for each college ordered by descending count.
SELECT COUNT(*), cname FROM tryout GROUP BY cname ORDER BY COUNT(*) DESC
SELECT COUNT(*), "cname" FROM "tryout" GROUP BY "cname" ORDER BY COUNT(*) DESC