name the sports team coach which has a coach tenure of assistant coach ?
Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity
m.0sgg1f0 m.02qwvmq m.085v7p m.0g9z4bd m.0kbqw_2 m.0wzrjbh m.01jjx5 m.025_f43 m.05b2pny m.062zw3 m.0gg9wk m.0bhjtp m.010qs4qv m.03c8zx m.047n3p_ m.0kbqwd7 m.03692d m.04145zn m.0_83wzt m.0bqc8v m.0fp9mbg m.0gmd4r3 m.0h959_j m.03ngbj m.048l93 m.0swnl2d m.010xd7pk m.02st_y m.04z69t m.0_v2snk m.0cq9dc m.0ynzr7y m.0yymsvz m.0zg6n2s m.05b2spd
Brandon Miller Brad Stevens Bernie Bickerstaff Mike Budenholzer Paul Hood Paul Clement Patrick Ewing Ettore Messina Frank Heinemann Nigel Lappin Steve Georgallis Max Rooke Craig Bonner Fernando Hierro Andries Jonker Dale Amos Marcus Allbäck Rhonda Faehn George Atkins Blake Caracella Rainer Widmayer James Rahilly Patrick Rahmen Jackie Stiles Becky Hammon Tony Miller Barry Davis Bryan Trottier Giuseppe Baresi Lee Davidson Matthew Knights Scott Carter Peter Horachek Ahmed Ayoub Bernd Hollerbach
class class entity
sports.sports_team_coach sports.sports_team_coach_tenure m.040zjnd
sports.sports_team_coach sports.sports_team_coach_tenure sports.coaching_position
Sports team coach Sports team coach tenure Assistant Coach
none none none
sports.sports_team_coach_tenure.coach sports.coaching_position.coaches
Coach Coaches
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 :sports.sports_team_coach . 
?x1 :type.object.type :sports.sports_team_coach_tenure . 
VALUES ?x2 { :m.040zjnd } 
?x1 :sports.sports_team_coach_tenure.coach ?x0 . 
?x2 :sports.coaching_position.coaches ?x1 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(AND sports.sports_team_coach (JOIN (R sports.sports_team_coach_tenure.coach) (JOIN (R sports.coaching_position.coaches) m.040zjnd)))