Show me the names of artists with no album.
select name from artist except select t2.name from album as t1 join artist as t2 on t1.artistid = t2.artistid
How many are there?
select count(*) from artist where artistid not in(select artistid from album)