How many student in total participate in the tryout?
select count ( * ) from tryout
For which colleges?
select count ( * ), cname from tryout group by cname
Can I see that list in a descending order based on student count?
select count ( * ), cname from tryout group by cname order by count ( * ) desc