May I know the album names and ids, and the number of tracks they have?
SELECT T1.title,T1.id,count ( T1.id )  FROM albums AS T1 JOIN tracks AS T2 ON T1.id  =  T2.album_id GROUP BY T1.id
album names and ids refers to T1.title, T1.id; number of tracks they have refers to COUNT(T2.album_id);