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

Find the average hours for the students whose tryout decision is no.
SELECT AVG(T1.HS) FROM player AS T1 JOIN tryout AS T2 ON T1.pID = T2.pID WHERE T2.decision = 'no'
SELECT AVG("T1"."HS") FROM "player" AS "T1" JOIN "tryout" AS "T2" ON "T1"."pID" = "T2"."pID" AND "T2"."decision" = 'no'