Task: Text to Code
Input (English): SQL: SELECT cName FROM College ORDER BY cName Asc
Feedback: Find player name of player table in ascending ordered whose player id present in tryout table .
Output (English): SELECT T1.pName FROM player AS T1 JOIN tryout AS T2 ON T1.pID  =  T2.pID ORDER BY T1.pName