Database: chinook_1
Question: How many artists do not have any album?
SQL:
SELECT count(*) FROM ARTIST WHERE artistid NOT IN(SELECT artistid FROM ALBUM)