Which colleges have students trying out?
select t1.cname from college as t1 join tryout as t2 on t1.cname = t2.cname
What are the different state they are located in?
select distinct state from college as t1 join tryout as t2 on t1.cname = t2.cname