CREATE TABLE tryout (pid NUMBER, cname CLOB, ppos CLOB, decision CLOB)
CREATE TABLE player (pid NUMBER, pname CLOB, ycard CLOB, hs NUMBER)
CREATE TABLE college (cname CLOB, state CLOB, enr NUMBER)

What are the names of the states that have some college students playing in the positions of goalie and mid-field?
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'
SELECT "T1"."state" FROM "college" "T1" JOIN "tryout" "T2" ON "T1"."cname" = "T2"."cname" AND "T2"."ppos" = 'goalie' INTERSECT SELECT "T1"."state" FROM "college" "T1" JOIN "tryout" "T2" ON "T1"."cname" = "T2"."cname" AND "T2"."ppos" = 'mid'