SELECT T1.Title ,  T2.AlbumID ,  COUNT(*) FROM ALBUM AS T1 JOIN TRACK AS T2 ON T1.AlbumId  =  T2.AlbumId GROUP BY T2.AlbumID
Show the album names, ids and the number of tracks for each album.
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
Show the album names , ids and the number of tracks for each album .