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
What were the decisions for each player?
assistant
SELECT T2.pNAME , decision FROM tryout AS T1 JOIN Player AS T2 ON T2.pID = T1.pID;
human
Which of the players received a yes?
assistant
SELECT T2.pNAME FROM tryout AS T1 JOIN Player AS T2 ON T2.pID = T1.pID WHERE decision = 'yes';
human
How many of them exist?
assistant
SELECT COUNT( * ) FROM tryout WHERE decision = "yes" ;