Database: soccer_2
Question: Find the players whose names contain letter 'a'.
SQL:
SELECT DISTINCT pName FROM Player WHERE pName LIKE '%a%'