Database: soccer_2
Question: Find the number of students who participate in the tryout for each college ordered by descending count.
SQL:
SELECT count(*) ,  cName FROM tryout GROUP BY cName ORDER BY count(*) DESC