CREATE TABLE Player (pName VARCHAR2)

Find the players whose names contain letter 'a'.
SELECT DISTINCT pName FROM Player WHERE pName LIKE '%a%'
SELECT DISTINCT "pName" FROM "Player" WHERE "pName" LIKE '%a%'