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%"
### Context: CREATE TABLE ARTIST (Name VARCHAR) ### Question: Find the names of all artists that have "a" in their names. ### Answer: SELECT Name FROM ARTIST WHERE Name LIKE "%a%"