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

How many students got accepted after the tryout?
SELECT COUNT(*) FROM tryout WHERE decision = 'yes'
SELECT COUNT(*) FROM "tryout" WHERE "decision" = 'yes'