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

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