what is the number of video game compilations with the genre of shooter games?
Value
4
class entity
cvg.computer_game_compilation m.02x9hs
cvg.computer_game_compilation cvg.cvg_genre
Video Game Compilation shooter games
count none
cvg.computer_videogame.cvg_genre
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 :cvg.computer_game_compilation . 
VALUES ?x1 { :m.02x9hs } 
?x0 :cvg.computer_videogame.cvg_genre ?x1 . 
FILTER ( ?x0 != ?x1  )
}
}
(COUNT (AND cvg.computer_game_compilation (JOIN cvg.computer_videogame.cvg_genre m.02x9hs)))