Show me tracks that belong to rock genre.
select t2.name from genre as t1 join track as t2 on t1.genreid = t2.genreid where t1.name = "Rock"
How many are there?
select count(*) from genre as t1 join track as t2 on t1.genreid = t2.genreid where t1.name = "Rock"