Find the players whose names contain letter 'a'.
CREATE TABLE Player (pName VARCHAR)
SELECT DISTINCT pName FROM Player WHERE pName LIKE '%a%'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Player (pName VARCHAR) Question: Find the players whose names contain letter 'a'. [/INST] SELECT DISTINCT pName FROM Player WHERE pName LIKE '%a%' </s>