how many video game child genres have horror?
(COUNT (AND cvg.cvg_genre (JOIN (R media_common.media_genre.child_genres) m.03npn)))