List the state and enrollment of all the colleges where any students got accepted in the tryout decision.
select distinct t1.state, t1.enr from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.decision = 'yes'
What are the states and names of the colleges that all the goalies tried out for?
select distinct t1.state, t1.enr from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.ppos = "goalie"
What are the states and names of all colleges that didn't accept students in the tryout decision?
select state, enr from college where cname not in ( select distinct t1.cname from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.decision = "yes" )