what is the number of video games designed by mark rogers?
Value
1
class entity
cvg.computer_videogame m.02hk_fn
cvg.computer_videogame cvg.cvg_designer
Video game Mark Rogers
count none
cvg.cvg_designer.games_designed
Games Designed
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.computer_videogame . 
VALUES ?x1 { :m.02hk_fn } 
?x1 :cvg.cvg_designer.games_designed ?x0 . 
FILTER ( ?x0 != ?x1  )
}
}
(COUNT (AND cvg.computer_videogame (JOIN (R cvg.cvg_designer.games_designed) m.02hk_fn)))