Hom many albums does the artist "Metallica" have?
SELECT COUNT(*) FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId  =  T2.ArtistId WHERE T2.Name  =  "Metallica"
albums by Metallica refers to COUNT(album_id) WHERE artist_name = 'Metallica';