Which players received a decision of no from tryouts?
select t1.pname from player as t1 join tryout as t2 on t1.pid = t2.pid where t2.decision = 'no'
How many hours did they practice?
select t1.pname, t1.hs from player as t1 join tryout as t2 on t1.pid = t2.pid where t2.decision = 'no'
What was the average?
select avg(t1.hs) from player as t1 join tryout as t2 on t1.pid = t2.pid where t2.decision = 'no'