Database: chinook_1
Question: What are the names and ids of the different albums, and how many tracks are on each?
SQL:
SELECT T1.Title ,  T2.AlbumID ,  COUNT(*) FROM ALBUM AS T1 JOIN TRACK AS T2 ON T1.AlbumId  =  T2.AlbumId GROUP BY T2.AlbumID