And for Metallica?
SELECT COUNT ( * )  FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId  =  T2.ArtistId WHERE T2.Name  =  "Metallica"
counting albums for a specific artist (Metallica) involves joining the ALBUM table with the ARTIST table on ArtistId and filtering where the artist's name is Metallica;