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

What are the names and hours spent practicing of every student who received a yes at tryouts?
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" "T1" JOIN "tryout" "T2" ON "T1"."pid" = "T2"."pid" AND "T2"."decision" = 'yes'