How 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"