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

Find the names of schools that have some students playing in goalie and mid positions.
SELECT cname FROM tryout WHERE ppos = 'goalie' INTERSECT SELECT cname FROM tryout WHERE ppos = 'mid'
SELECT "cname" FROM "tryout" WHERE "ppos" = 'goalie' INTERSECT SELECT "cname" FROM "tryout" WHERE "ppos" = 'mid'