CREATE TABLE tryout (pID VARCHAR2, decision VARCHAR2)
CREATE TABLE player (HS NUMBER, pID VARCHAR2)

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