Find the names of all artists that have "a" in their names.
CREATE TABLE ARTIST (Name VARCHAR)
SELECT Name FROM ARTIST WHERE Name LIKE "%a%"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE ARTIST (Name VARCHAR) Question: Find the names of all artists that have "a" in their names. [/INST] SELECT Name FROM ARTIST WHERE Name LIKE "%a%" </s>