Show me the names and ids of each album.
select t1.title, t2.albumid from album as t1 join track as t2 on t1.albumid = t2.albumid group by t2.albumid
Show me the number of tracks each album has as well.
select t1.title, t2.albumid, count(*) from album as t1 join track as t2 on t1.albumid = t2.albumid group by t2.albumid