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%"