What is {cast member} of {The Rocky Horror Picture Show} that is {character role} is {Rocky Horror} ?
Which actor was cast as Rocky Horror for The Rocky Horror Picture Show?
Who was cast as Rocky Horror for The Rocky Horror Picture Show?
SELECT ?x WHERE { resource:The_Rocky_Horror_Picture_Show property:cast_member ?b . ?b property:character_role resource:Rocky_Horror . ?b property:cast_member ?x }
select distinct ?obj  where {
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#subject> <http://wikidata.dbpedia.org/resource/Q751921> .
?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> ?obj .
?statement <http://www.wikidata.org/entity/P453> <http://wikidata.dbpedia.org/resource/Q13500542>
} 

SELECT ?obj WHERE { wd:Q751921 p:P161 ?s . ?s ps:P161 ?obj . ?s pq:P453 wd:Q13500542 }