CREATE TABLE ARTIST (artistid VARCHAR)
CREATE TABLE ALBUM (artistid VARCHAR)

How many artists do not have any album?
SELECT COUNT(*) FROM ARTIST WHERE NOT artistid IN (SELECT artistid FROM ALBUM)
SELECT COUNT(*) FROM "ARTIST" WHERE NOT "artistid" IN (SELECT "artistid" FROM "ALBUM")