Hi there! Can you provide me with a list of all of the player names?
select pname from player
Thank you for that! Can you filter the list to show the names of only the players whose decision is "yes"?
select t1.pname from player as t1 join tryout as t2 on t1.pid = t2.pid where t2.decision = 'yes'
Perfect!  Can you update this list to show the college names associated with each of these 2 players?
select t1.pname ,t2.cname from player as t1 join tryout as t2 on t1.pid = t2.pid where t2.decision = 'yes'