How many students participated in tryouts for each college?
select count(*), cname from tryout group by cname
Order them by number of participants.
select count(*), cname from tryout group by cname order by count(*)
Make sure it is in descending order.
select count(*), cname from tryout group by cname order by count(*) desc