Find the players whose names contain letter 'a'.
select distinct pname from player where pname like '%a%'