What is the name of the college each student trying out from?
select cname from tryout
What are the different college names?
select distinct cname from tryout
How many different ones exist?
select count(distinct cname) from tryout