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

How many schools have students playing in goalie and mid-field positions?
SELECT COUNT(*) FROM (SELECT cname FROM tryout WHERE ppos = 'goalie' INTERSECT SELECT cname FROM tryout WHERE ppos = 'mid')
WITH "cte" AS (SELECT "cname" FROM "tryout" WHERE "ppos" = 'goalie' INTERSECT SELECT "cname" FROM "tryout" WHERE "ppos" = 'mid') SELECT COUNT(*) FROM "cte" AS "cte"