What are the names of colleges that have students who tried out for the goalie?
select t1.cname from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.ppos = 'goalie'
What states are they located in?
select t1.state from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.ppos = 'goalie'
Of those states, which also have colleges where students tried out for mid-field?
select t1.state from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.ppos = 'goalie' intersect select t1.state from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.ppos = 'mid'