How many artists don't have any albums?
select count(*) from artist except select t2.name from album as t1 join artist as t2 on t1.artistid = t2.artistid
Find me their names.
select name from artist except select t2.name from album as t1 join artist as t2 on t1.artistid = t2.artistid