which tv crew has the shortest employment tenure?
Entity
m.04jsh6f
Pete Huyck
class class literal
tv.tv_crewmember business.employment_tenure 0^^http://www.w3.org/2001/XMLSchema#int
tv.tv_crewmember business.employment_tenure type.datetime
TV crewmember Employment tenure 0
none none argmin
people.person.employment_history business.employment_tenure.to
Employment history To
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 :tv.tv_crewmember . 
?x1 :type.object.type :business.employment_tenure . 
{
SELECT (MIN(?y2) AS ?x2)  WHERE { 
?y0 :type.object.type :tv.tv_crewmember . 
?y1 :type.object.type :business.employment_tenure . 
?y0 :people.person.employment_history ?y1 . 
?y1 :business.employment_tenure.to ?y2 . 
FILTER ( ?y0 != ?y1 && ?y0 != ?y2 && ?y1 != ?y2  )
}
}
?x0 :people.person.employment_history ?x1 . 
?x1 :business.employment_tenure.to ?x2 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(ARGMIN tv.tv_crewmember (JOIN people.person.employment_history business.employment_tenure.to))