SELECT count(*) ,  cName FROM tryout GROUP BY cName ORDER BY count(*) DESC
How many students participated in tryouts for each college by descennding 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
How many students participated in tryouts for each college by descennding count ?