-- WHAT ALBUMS THE LED ZEPPELIN HAVE?
SELECT 
  r.Name AS ArtistName,
  COUNT(l.Title)
FROM artists_test AS r  --LEFT TABLE
LEFT JOIN _albums AS l --RIGHT TABLE
	ON r.ArtistId = l.ArtistId
WHERE l.Title is NULL
GROUP BY ArtistName
--ORDER BY NrAlbums DESC