What are all the players names?
select pname from player
Which of those players tried out and received a yes?
select t1.pname from player as t1 join tryout as t2 on t1.pid = t2.pid where t2.decision = 'yes'
Also, what colleges are they from?
select t1.pname, t2.cname from player as t1 join tryout as t2 on t1.pid = t2.pid where t2.decision = 'yes'