Table schema:
CREATE TABLE ARTIST (Name VARCHAR)

Question: Find the names of all artists that have "a" in their names.
SQL: SELECT Name FROM ARTIST WHERE Name LIKE "%a%"