Database: chinook_1
Question: Cound the number of artists who have not released an album.
SQL:
SELECT count(*) FROM ARTIST WHERE artistid NOT IN(SELECT artistid FROM ALBUM)