Database: chinook_1
Question: Count the number of tracks that are part of the rock genre.
SQL:
SELECT COUNT(*) FROM GENRE AS T1 JOIN TRACK AS T2 ON T1.GenreId  =  T2.GenreId WHERE T1.Name  =  "Rock"