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

What are the names of all schools that have students trying out for the position of goal and 'mid'-field.
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'