the player who plays for csc cayenne plays what positions?
Entity Entity Entity Entity
m.02nzb8 m.02_j1w m.02sdk9v m.0dgrmp
Midfielder Defender Forward Goalkeeper
class class entity
sports.sports_position sports.sports_team_roster m.0h3sk6v
sports.sports_position sports.sports_team_roster soccer.football_team
Sports position Sports team roster CSC Cayenne
none none none
sports.sports_position.players sports.sports_team_roster.team
Players Team
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_position . 
?x1 :type.object.type :sports.sports_team_roster . 
VALUES ?x2 { :m.0h3sk6v } 
?x0 :sports.sports_position.players ?x1 . 
?x1 :sports.sports_team_roster.team ?x2 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(AND sports.sports_position (JOIN sports.sports_position.players (JOIN sports.sports_team_roster.team m.0h3sk6v)))