Can you tell me the player id of each player with the letter 'a' in their name?
select pid from player where pname like '%a%'
How many of those players have a yes card?
select count ( * ) from player where pname like '%a%' and ycard = "yes"
What are those players' names?
select distinct pname from player where pname like '%a%' and ycard = "yes"