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