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
Can you tell me the player id of each player with the letter 'a' in their name?
assistant
SELECT pid FROM Player WHERE pName LIKE '%a%';
human
How many of those players have a yes card?
assistant
SELECT COUNT( * ) FROM Player WHERE pName LIKE '%a%' AND yCard = 'yes';
human
What are those players' names?
assistant
SELECT DISTINCT pName FROM Player WHERE pName LIKE "%a%" AND yCard = "yes" ;