What are the names of the states that have some college students playing in the mid position but not the goalie position?
select t1.state from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.ppos = 'mid' except select t1.state from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.ppos = 'goalie'
What about states that have some college students playing in the goalie position?
select t1.state from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.ppos = 'goalie'
What about in the striker position?
select t1.state from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.ppos = 'striker'
What is the college name for that one?
select t1.cname from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.ppos = 'striker'
Was there a decision on that position?
select decision from tryout where ppos = 'striker'