how many themes for amusement rides do they have at canopy flyer?
Value
1
class entity
amusement_parks.ride_theme m.0b__mn6
amusement_parks.ride_theme amusement_parks.roller_coaster
Amusement Ride Theme Canopy Flyer
count none
amusement_parks.ride.theme
Theme
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 :amusement_parks.ride_theme . 
VALUES ?x1 { :m.0b__mn6 } 
?x1 :amusement_parks.ride.theme ?x0 . 
FILTER ( ?x0 != ?x1  )
}
}
(COUNT (AND amusement_parks.ride_theme (JOIN (R amusement_parks.ride.theme) m.0b__mn6)))