Query: spotify_top_genres_by_tracks

select
  rag.genre_id,
  count(distinct t.id) as "Number of Tracks"
from
  tracks t
  join r_track_artist rta on t.id = rta.track_id
  join r_artist_genre rag on rta.artist_id = rag.artist_id
group by
  rag.genre_id
order by
  "Number of Tracks" desc
limit
  10;