* I have left the chat *
SELECT T1.Title ,  T2.AlbumID ,  COUNT ( * )  FROM ALBUM AS T1 JOIN TRACK AS T2 ON T1.AlbumId   =   T2.AlbumId GROUP BY T2.AlbumID
To retrieve titles from Album and count of tracks in each album, join Album and Track tables on AlbumId; use GROUP BY on AlbumId to aggregate results per album.