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)

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" AS "T1" JOIN "tryout" AS "T2" ON "T1"."pid" = "T2"."pid" AND "T2"."decision" = 'yes'