Give me {private not-for-profit educational institution} that {subsidiary} {Lamont–Doherty Earth Observatory} and which contains the word {columbia} in their name
What is a subsidiary of Lamont-Doherty Earth Observatory that is a private, non-profit academic institution with the phrase "Columbia" in its name?
What is a subsidiary of Lamont-Doherty Earth Observatory that is a private, non-profit educational institution with the word "Columbia" in its name?
SELECT DISTINCT ?r WHERE { ?r rdf:type ontology:private_not-for-profit_educational_institution . ?r property:subsidiary resource:Lamont–Doherty_Earth_Observatory . FILTER ( CONTAINS ( LCASE ( ?r ) , 'columbia' ) ) }
SELECT DISTINCT ?sbj ?sbj_label { ?statement1 <http://www.w3.org/1999/02/22-rdf-syntax-ns#subject> ?sbj . ?statement1 <http://www.w3.org/1999/02/22-rdf-syntax-ns#predicate> <http://www.wikidata.org/entity/P31> . ?statement1 <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> <http://wikidata.dbpedia.org/resource/Q23002054>. ?statement2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#subject> ?sbj . ?statement2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#predicate> <http://www.wikidata.org/entity/P355> . ?statement2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> <http://wikidata.dbpedia.org/resource/Q34051>. ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'columbia')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25
SELECT DISTINCT ?sbj ?sbj_label WHERE { ?sbj wdt:P31 wd:Q23002054 . ?sbj wdt:P355 wd:Q34051 . ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'columbia')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25 
Columbia University Columbia University