what is the {for work} for {John Barry} has {award received} as {Academy Award for Best Original Score, no Musical} ?
What was the non-musical movie that John Barry received an Oscar for?
What was the work John Barry received the Academy Award for Best Original Score that was not a musical?
SELECT ?b WHERE { resource:John_Barry property:award_received ?z . ?z property:award_received resource:Academy_Award_for_Best_Original_Score,_no_Musical . ?z property:for_work ?b }
select distinct ?value  where {
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#subject> <http://wikidata.dbpedia.org/resource/Q111074> .
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#predicate> <http://www.wikidata.org/entity/P166> .
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> <http://wikidata.dbpedia.org/resource/Q22752734> .
?statement <http://www.wikidata.org/entity/P1686> ?value. 
} 

SELECT ?value WHERE { wd:Q111074 p:P166 ?s . ?s ps:P166 wd:Q22752734 . ?s pq:P1686 ?value}