CREATE TABLE player (pName VARCHAR, HS VARCHAR, pID VARCHAR)
CREATE TABLE tryout (pID VARCHAR, decision VARCHAR)

Find the name and hours of the students whose tryout decision is yes.
SELECT T1.pName, T1.HS FROM player AS T1 JOIN tryout AS T2 ON T1.pID = T2.pID WHERE T2.decision = 'yes'
SELECT "T1"."pName", "T1"."HS" FROM "player" AS "T1" JOIN "tryout" AS "T2" ON "T1"."pID" = "T2"."pID" AND "T2"."decision" = 'yes'