How many tracks are in the Rock genre?
select count ( t2.id ) from genres as t1 join tracks as t2 on t1.id = t2.genre_id where t1.name = "Rock"
Show me the name of tracks in the Rock genre.
select t2.name from genres as t1 join tracks as t2 on t1.id = t2.genre_id where t1.name = "Rock"
What is the average unit price for tracks in the Rock genre?
select avg ( t2.unit_price ) from genres as t1 join tracks as t2 on t1.id = t2.genre_id where t1.name = "Rock"
How many tracks are in the Jazz genre?
select count ( t2.name ) from genres as t1 join tracks as t2 on t1.id = t2.genre_id where t1.name = "Jazz"
How many milliseconds is the Rock genre track Balls to the Wall?
select t2.milliseconds from genres as t1 join tracks as t2 on t1.id = t2.genre_id where t1.name = "Rock" and t2.name = 'Balls to the Wall'