find the mission that scaled composites tier one was a part of.
Entity Entity Entity Entity Entity
m.0j712yw m.037f2p m.0j712yj m.03fvds m.03jfhl
SpaceShipOne flight 01C SpaceShipOne flight 15P SpaceShipOne flight 11P SpaceShipOne flight 16P SpaceShipOne flight 17P
class entity
spaceflight.space_mission m.037lm3
spaceflight.space_mission spaceflight.space_program
Space Mission Scaled Composites Tier One
none none
spaceflight.space_mission.space_program
Space program
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 (?x0 AS ?value) WHERE {
SELECT DISTINCT ?x0  WHERE { 
?x0 :type.object.type :spaceflight.space_mission . 
VALUES ?x1 { :m.037lm3 } 
?x0 :spaceflight.space_mission.space_program ?x1 . 
FILTER ( ?x0 != ?x1  )
}
}
(AND spaceflight.space_mission (JOIN spaceflight.space_mission.space_program m.037lm3))