Find number of tracks in each genre?
create table tracks (genre_id varchar, PRIMARY KEY (genre_id)); create table genres (name varchar, id varchar, PRIMARY KEY (name))
select count(*), t1.name from genres as t1 join tracks as t2 on t1.id = t2.genre_id group by t1.name