CREATE TABLE tryout (cName VARCHAR(255), pPos VARCHAR(255)); CREATE TABLE college (state VARCHAR(255), cName VARCHAR(255))
Find the names of states that have some college students playing in goalie and mid positions.
    
SQL: 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'