how many film characters of the cavemen species have an occupation of reporter?
Value
2
class entity entity
film.film_character m.01b8xr m.0344mz
film.film_character fictional_universe.character_occupation fictional_universe.character_species
Film character Reporter cavemen
count none none
fictional_universe.character_occupation.characters_with_this_occupation fictional_universe.fictional_character.species
Characters With This Occupation Species
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 :film.film_character . 
VALUES ?x1 { :m.01b8xr } 
VALUES ?x2 { :m.0344mz } 
?x1 :fictional_universe.character_occupation.characters_with_this_occupation ?x0 . 
?x0 :fictional_universe.fictional_character.species ?x2 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(COUNT (AND film.film_character (AND (JOIN (R fictional_universe.character_occupation.characters_with_this_occupation) m.01b8xr) (JOIN fictional_universe.fictional_character.species m.0344mz))))