What are the players' names?
select pname from player
Which of them tried out?
select t1.pname from player as t1 join tryout as t2 on t1.pid = t2.pid
Sort the list alphabetically.
select t1.pname from player as t1 join tryout as t2 on t1.pid = t2.pid order by t1.pname