SELECT T1.Title ,  T2.AlbumID ,  COUNT(*) FROM ALBUM AS T1 JOIN TRACK AS T2 ON T1.AlbumId  =  T2.AlbumId GROUP BY T2.AlbumID
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
select t1 . title , t2 . albumid , count ( * ) from album as t1 join track as t2 on t1 . albumid = t2 . albumid group by t2 . albumid
What are the names and ids of the different albums , and how many tracks are on each ?