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

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'
SELECT "T1"."state" FROM "college" AS "T1" JOIN "tryout" AS "T2" ON "T1"."cname" = "T2"."cname" AND "T2"."ppos" = 'goalie' INTERSECT SELECT "T1"."state" FROM "college" AS "T1" JOIN "tryout" AS "T2" ON "T1"."cname" = "T2"."cname" AND "T2"."ppos" = 'mid'