What is {employer} of {Nora Ephron} and {duration}
Who is the employer of Nora Ephron and how long has she been employed?
Who employs Nora Ephron and how long has she been employed?
SELECT ?y ?t WHERE { ?k property:employer ?t . resource:Nora_Ephron property:employer ?k . ?k property:duration ?y . }
select distinct ?dataprop1 ?obj where { ?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#subject> <http://wikidata.dbpedia.org/resource/Q214677> . ?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#predicate> <http://www.wikidata.org/entity/P108> . ?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> ?obj . ?statement <http://www.wikidata.org/entity/P580> ?dataprop1 . } 
SELECT ?value1 ?obj WHERE { wd:Q214677 p:P108 ?s . ?s ps:P108 ?obj . ?s pq:P2047 ?value1 . }