Task: Text to Code
Input (English): Find the number of albums by the artist "Metallica".
Output (English): SELECT COUNT(*) FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId  =  T2.ArtistId WHERE T2.Name  =  "Metallica"