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)

What are the names of all the players who received a yes during tryouts, and also what are the names of their colleges?
SELECT T1.pname, T2.cname FROM player AS T1 JOIN tryout AS T2 ON T1.pid = T2.pid WHERE T2.decision = 'yes'
SELECT "T1"."pname", "T2"."cname" FROM "player" "T1" JOIN "tryout" "T2" ON "T1"."pid" = "T2"."pid" AND "T2"."decision" = 'yes'