Yes please
select id,name from genres order by id desc limit 5
Could you please provide the total tracks on each top 5 genres by number of tracks?
select t1.id,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
Do you have the best composer of each top 5 genre by number of tracks?
select t1.id,t2.composer from genres as t1 join tracks as t2 on t2.genre_id = t1.id group by t1.id order by count ( * ) desc limit 5
Yes please.
select composer from tracks order by milliseconds