How many states that have some college students playing in the mid position?
select count ( * ) from ( select t1.state from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.ppos = 'mid' )
How many states that have some college students not playing in the goalie position?
select count ( * ) from ( select t1.state from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.ppos ! = 'goalie' )
Find college names with students playing in the goalie position
select cname from tryout where ppos = "goalie"