How many artists do not have any album?
create table artist (artistid varchar, PRIMARY KEY (artistid)); create table album (artistid varchar, PRIMARY KEY (artistid))
select count(*) from artist where not artistid in (select artistid from album)