human
Schema:
College (cName, state, enr)
Player (pID, pName, yCard, HS)
Tryout (pID, cName, pPos, decision)
Please answer with SQL.
assistant
Sure, I understand.
human
Hi there! Can you provide me with a list of all of the player names?
assistant
SELECT pName FROM player;
human
Thank you for that! Can you filter the list to show the names of only the players whose decision is 'yes'?
assistant
SELECT T1.pName FROM player AS T1 JOIN tryout AS T2 ON T1.pID = T2.pID WHERE T2.decision = "yes" ;