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

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'