what is the number of media genres whose parent genre is educational film?
Value
2
class entity
media_common.media_genre m.04zgj2
media_common.media_genre media_common.literary_genre
Media genre Educational film
count none
media_common.media_genre.parent_genre
Parent genre
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 :media_common.media_genre . 
VALUES ?x1 { :m.04zgj2 } 
?x0 :media_common.media_genre.parent_genre ?x1 . 
FILTER ( ?x0 != ?x1  )
}
}
(COUNT (AND media_common.media_genre (JOIN media_common.media_genre.parent_genre m.04zgj2)))