what are the college names of the students whose tryout decision is yes
select cname from tryout where decision = "yes"
what is the average and maximum hours for these students
select avg ( t1.hs ), max ( t1.hs ) from player as t1 join tryout as t2 on t1.pid = t2.pid where t2.decision = 'yes'
add the player id and college names in the same list
select avg ( t1.hs ), max ( t1.hs ), t1.pid, t2.cname from player as t1 join tryout as t2 on t1.pid = t2.pid where t2.decision = 'yes'