Find the names of all artists whose names end with "b".
select name from artist where name like "%b"
How about artists whose names contain "b"?
select name from artist where name like "%b%"
Now do the same for "a".
select name from artist where name like "%a%"