SELECT count(*) FROM ARTIST WHERE artistid NOT IN(SELECT artistid FROM ALBUM)
Cound the number of artists who have not released an album.
SELECT count ( * ) FROM ARTIST WHERE artistid NOT IN ( SELECT artistid FROM ALBUM )
select count ( * ) from artist where artistid not in ( select artistid from album )
Cound the number of artists who have not released an album .