What are the names of colleges that have students who made the team?
select t1.cname from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.decision = 'yes'
How many students are enrolled in each of them?
select t1.enr from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.decision = 'yes'
Also, what are the different states in which those colleges reside?
select distinct t1.state, t1.enr from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.decision = 'yes'