How many tracks are there?
select count(*) from tracks
What are the names, composers, and genre names of each?
select t2.name, t2.composer, t1.name from genres as t1 join tracks as t2 on t2.genre_id = t1.id;
Show how many tracks there are per genre!
select t1.name, count(*) from genres as t1 join tracks as t2 on t2.genre_id = t1.id group by t1.id;
Show the genre names, and number of tracks of the top 5 by number of tracks!
select t1.name, count(*) from genres as t1 join tracks as t2 on t2.genre_id = t1.id group by t1.id order by count(*) desc limit 5;