What are the name of the colleges that had students participate in tryouts?
select t1.cname from college as t1 join tryout as t2 on t1.cname = t2.cname
Of those colleges, which had students that received a yes?
select t1.cname from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.decision = 'yes'
What are the different states those colleges are located in?
select distinct t1.state from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.decision = 'yes'