bill koch coaches what american football team?
Entity
m.0k0tm86
Valparaiso Crusaders football
class class entity
american_football.football_team sports.sports_team_coach_tenure m.0_1k3kf
american_football.football_team sports.sports_team_coach_tenure sports.sports_team_coach
American football team Sports team coach tenure Bill Koch
none none none
sports.sports_team.coaches sports.sports_team_coach_tenure.coach
Coaches Coach
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 :american_football.football_team . 
?x1 :type.object.type :sports.sports_team_coach_tenure . 
VALUES ?x2 { :m.0_1k3kf } 
?x0 :sports.sports_team.coaches ?x1 . 
?x1 :sports.sports_team_coach_tenure.coach ?x2 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(AND american_football.football_team (JOIN sports.sports_team.coaches (JOIN sports.sports_team_coach_tenure.coach m.0_1k3kf)))