Find number of tracks in each genre?
SELECT count(*) ,  T1.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id GROUP BY T1.name;
SELECT count(*) ,  T1.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id GROUP BY T1.name;
[{'count(*)': 40, 'name': 'Alternative'}, {'count(*)': 332, 'name': 'Alternative & Punk'}, {'count(*)': 81, 'name': 'Blues'}, {'count(*)': 15, 'name': 'Bossa Nova'}, {'count(*)': 74, 'name': 'Classical'}, {'count(*)': 17, 'name': 'Comedy'}, {'count(*)': 64, 'name': 'Drama'}, {'count(*)': 24, 'name': 'Easy Listening'}, {'count(*)': 30, 'name': 'Electronica/Dance'}, {'count(*)': 28, 'name': 'Heavy Metal'}, {'count(*)': 35, 'name': 'Hip Hop/Rap'}, {'count(*)': 130, 'name': 'Jazz'}, {'count(*)': 579, 'name': 'Latin'}, {'count(*)': 374, 'name': 'Metal'}, {'count(*)': 1, 'name': 'Opera'}, {'count(*)': 48, 'name': 'Pop'}, {'count(*)': 61, 'name': 'R&B/Soul'}, {'count(*)': 58, 'name': 'Reggae'}, {'count(*)': 1297, 'name': 'Rock'}, {'count(*)': 12, 'name': 'Rock And Roll'}, {'count(*)': 26, 'name': 'Sci Fi & Fantasy'}, {'count(*)': 13, 'name': 'Science Fiction'}, {'count(*)': 43, 'name': 'Soundtrack'}, {'count(*)': 93, 'name': 'TV Shows'}, {'count(*)': 28, 'name': 'World'}]