Database: soccer_2
Question: How many students participated in tryouts for each college by descennding count?
SQL:
SELECT count(*) ,  cName FROM tryout GROUP BY cName ORDER BY count(*) DESC