what is the {character role} for {ER} has {cast member} as {Noah Wyle} ?
Noah Wyle played who in ER
For which ER's character was Noah Wyle cast?
SELECT ?v WHERE { resource:ER property:cast_member ?e . ?e property:cast_member resource:Noah_Wyle . ?e property:character_role ?v }
select distinct ?value  where {
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#subject> <http://wikidata.dbpedia.org/resource/Q207375> .
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#predicate> <http://www.wikidata.org/entity/P161> .
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> <http://wikidata.dbpedia.org/resource/Q315208> .
?statement <http://www.wikidata.org/entity/P453> ?value. 
} 

SELECT ?value WHERE { wd:Q207375 p:P161 ?s . ?s ps:P161 wd:Q315208 . ?s pq:P453 ?value}