CREATE TABLE tryout (cName VARCHAR2)

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