What are the names and ids of the different albums, and how many tracks are on each?
select t1.title, t2.albumid, count(*) from album as t1 join track as t2 on t1.albumid = t2.albumid group by t2.albumid