how many ice hockey coaches have the michigan state spartans men's ice hockey had?
Value
1
class entity
ice_hockey.hockey_coach m.02x0_cn
ice_hockey.hockey_coach ice_hockey.hockey_team
Ice hockey coach Michigan State Spartans men's ice hockey
count none
ice_hockey.hockey_coach.current_team
Current Team Coached
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 (COUNT(?x0) AS ?value) WHERE {
SELECT DISTINCT ?x0  WHERE { 
?x0 :type.object.type :ice_hockey.hockey_coach . 
VALUES ?x1 { :m.02x0_cn } 
?x0 :ice_hockey.hockey_coach.current_team ?x1 . 
FILTER ( ?x0 != ?x1  )
}
}
(COUNT (AND ice_hockey.hockey_coach (JOIN ice_hockey.hockey_coach.current_team m.02x0_cn)))