Database: chinook_1
Question: Find the number of albums by the artist "Metallica".
SQL:
SELECT COUNT(*) FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId  =  T2.ArtistId WHERE T2.Name  =  "Metallica"