whose primary occupation was author but was one of the shortest astronauts?
Entity
m.0hfml
Buzz Aldrin
class entity literal
spaceflight.astronaut m.0kyk 0^^http://www.w3.org/2001/XMLSchema#int
spaceflight.astronaut people.profession type.float
Astronaut Author 0
none none argmin
people.person.profession people.person.height_meters
Profession Height
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.astronaut . 
VALUES ?x1 { :m.0kyk } 
{
SELECT (MIN(?y2) AS ?x2)  WHERE { 
?y0 :type.object.type :spaceflight.astronaut . 
VALUES ?y1 { :m.0kyk } 
?y0 :people.person.profession ?y1 . 
?y0 :people.person.height_meters ?y2 . 
FILTER ( ?y0 != ?y1 && ?y0 != ?y2 && ?y1 != ?y2  )
}
}
?x0 :people.person.profession ?x1 . 
?x0 :people.person.height_meters ?x2 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(ARGMIN (AND spaceflight.astronaut (JOIN people.person.profession m.0kyk)) people.person.height_meters)