What information is there on players whose name contains the letter a?
select * from player where pname like '%a%'
What are their names?
select pname from player where pname like '%a%'
What is a list of the unique names?
select distinct pname from player where pname like '%a%'