Project:SPARQL/examples: Difference between revisions

Project:SPARQL/examples (view source)

Revision as of 16:23, 28 July 2023

1,975 bytes added , 9 months ago

→‎People

Drjwbaker

Bureaucrats, Administrators

7,354

edits

@@ Line 804: / Line 804: @@
 GROUP BY ?organisation ?organisationLabel
 ORDER BY DESC(?organisation_count)
+</sparql>
+===Women educated at a tertiary educational institution located in Oxford or Cambridge===
+<sparql tryit="1">
+# Women educated at a tertiary educational institution located in Oxford or Cambridge
+PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
+PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
+PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
+PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
+PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
+PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+SELECT ?woman ?womanLabel ?educationalinstitution ?educationalinstitutionLabel ?location ?locationLabel
+WHERE {
+  {?woman bnwdt:P3 bnwd:Q3 . #filter women
+  ?woman bnwdt:P94 ?educationalinstitution . #find 'educated at' statement
+  ?educationalinstitution bnwdt:P12 bnwd:Q2914 . #filter to tertiary educational institutions
+  ?educationalinstitution bnwdt:P2 ?location . #find location of educational institution
+  ?location rdfs:label ?locationLabel .
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+  FILTER(LANG(?locationLabel) = "en") .
+  FILTER(regex(?locationLabel, "oxford", "i")) .}
+  UNION
+  {?woman bnwdt:P3 bnwd:Q3 . #filter women
+  ?woman bnwdt:P94 ?educationalinstitution . #find 'educated at' statement
+  ?educationalinstitution bnwdt:P12 bnwd:Q2914 . #filter to tertiary educational institutions
+  ?educationalinstitution bnwdt:P2 ?location . #find location of educational institution
+  ?location rdfs:label ?locationLabel .
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+  FILTER(LANG(?locationLabel) = "en") .
+  FILTER(regex(?locationLabel, "Cambridge$", "i")) .}
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+}
+ORDER BY ?womanLabel
 </sparql>