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"
tracks in the rock genre refers to COUNT(*) where genre name is Rock; joining tables on GenreId to count tracks.