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

How many students received a yes from tryouts?
SELECT COUNT(*) FROM tryout WHERE decision = 'yes'
SELECT COUNT(*) FROM "tryout" WHERE "decision" = 'yes'