In the rock genre, how many tracks are there?
select count ( * ) from genre as t1 join track as t2 on t1.genreid = t2.genreid where t1.name = "Rock"
What about jazz?
select count ( * ) from genre as t1 join track as t2 on t1.genreid = t2.genreid where t1.name = "Jazz"
Can you list the composer who wrote the most rock genre songs?
select composer from genre as t1 join track as t2 on t1.genreid = t2.genreid where t1.name = "Rock" group by composer order by count ( * ) desc limit 1
Can you list all composers who wrote tracks with the letter B in their name?
select composer from track where name like "%b%"