CREATE TABLE tryout (cName VARCHAR2, pID VARCHAR2, decision VARCHAR2)
CREATE TABLE player (pName VARCHAR2, pID VARCHAR2)

Find the name and college of students whose decisions are yes in the tryout.
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'