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
Hmm, can you list the album names and the artist ids?
select title,artist_id from albums
Can you also list the title of albums that have the number of tracks greater than 10?
select t1.title from albums as t1 join tracks as t2 on t1.id = t2.album_id group by t1.id having count ( t1.id ) > 10