how many video game child genres have horror?
Value
2
class entity
cvg.cvg_genre m.03npn
cvg.cvg_genre comic_strips.comic_strip_genre
Video Game Genre Horror
count none
media_common.media_genre.child_genres
Child genres
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX : <http://rdf.freebase.com/ns/> 
SELECT (COUNT(?x0) AS ?value) WHERE {
SELECT DISTINCT ?x0  WHERE { 
?x0 :type.object.type :cvg.cvg_genre . 
VALUES ?x1 { :m.03npn } 
?x1 :media_common.media_genre.child_genres ?x0 . 
FILTER ( ?x0 != ?x1  )
}
}
(COUNT (AND cvg.cvg_genre (JOIN (R media_common.media_genre.child_genres) m.03npn)))