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

Find the names of the students who are in the position of striker and got a yes tryout decision.
SELECT T1.pname FROM player AS T1 JOIN tryout AS T2 ON T1.pid = T2.pid WHERE T2.decision = 'yes' AND T2.ppos = 'striker'
SELECT "T1"."pname" FROM "player" "T1" JOIN "tryout" "T2" ON "T1"."pid" = "T2"."pid" AND "T2"."decision" = 'yes' AND "T2"."ppos" = 'striker'