Show me all the albums from "Metallica".
select * from album as t1 join artist as t2 on t1.artistid = t2.artistid where t2.name = "Metallica"
How many are there?
select count(*) from album as t1 join artist as t2 on t1.artistid = t2.artistid where t2.name = "Metallica"