-- Database schema
| College : cName [ TEXT ] primary_key , state [ TEXT ] , enr [ INT ] | Player : pID [ INT ] primary_key , pName [ TEXT ] , yCard [ TEXT ] , HS [ INT ] | Tryout : pID [ INT ] primary_key Tryout.pID = Player.pID , cName [ TEXT ] Tryout.cName = College.cName , pPos [ TEXT ] , decision [ TEXT ] |
-- -- Find the names of states that have some college students playing in goalie and mid positions.

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';