SELECT count(*) ,  cName FROM tryout GROUP BY cName ORDER BY count(*) DESC
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
Find the number of students who participate in the tryout for each college ordered by descending count .