Project:SPARQL/examples: Difference between revisions

Project:SPARQL/examples (view source)

1,378 bytes added , 1 year ago

7,354

edits

@@ Line 443: / Line 443: @@
 }
 ORDER BY ?personLabel
+</sparql>
+===Membership of organisations by women, sorted by how many women were members of a given organisation===
+<sparql tryit="1">
+# Membership of organisations by women, sorted by how many women were members of a given organisation
+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 ?organisation ?organisationLabel (count(?organisation) as ?organisation_count) #count number of organisations that women were members of
+WHERE {
+  ?person bnwdt:P3 bnwd:Q3 . # select women
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  ?person bnwdt:P67 ?organisation . # selection people who were members of organisations and what those organisations were
+  FILTER NOT EXISTS {?person bnwdt:P67 bnwd:Q35 .} # filter out Royal Archaeological Institute
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+GROUP BY ?organisation ?organisationLabel
+ORDER BY DESC(?organisation_count)
 </sparql>