SELECT DISTINCT pName FROM Player WHERE pName LIKE '%a%'
Who are the players that have names containing the letter a?
SELECT DISTINCT pName FROM Player WHERE pName LIKE ' % a % '
select distinct pname from player where pname like value
Who are the players that have names containing the letter a ?