Task: Text to Code
Input (English): SQL: SELECT T1.state FROM College AS T1 JOIN Tryout AS T2 ON T1.cName = T2.cName WHERE T2.pPos = "goalie" INTERSECT SELECT T2.cName FROM Tryout AS T2 WHERE T2.pPos = "mid"
Feedback: In step 3 , need to find "state" instead of "Tryout's college name of tryout table"
Output (English): 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'