Find the number of students who participate in the tryout for each college ordered by descending count.
CREATE TABLE tryout (cName VARCHAR)
[SQL] SELECT COUNT(*), cName FROM tryout GROUP BY cName ORDER BY COUNT(*) DESC [/SQL]