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

How many students whose are playing the role of goalie?
SELECT COUNT(*) FROM tryout WHERE ppos = 'goalie'
SELECT COUNT(*) FROM "tryout" WHERE "ppos" = 'goalie'