7,354
edits
Project:SPARQL/examples: Difference between revisions
→Women in our data alongside counts of their public and professional activities
(add ppa count) |
|||
| Line 268: | Line 268: | ||
</sparql> | </sparql> | ||
===Women in our data alongside counts of their public and professional activities=== | ===Women in our data alongside counts of their public and professional activities, sorted by total=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
## Women in our data alongside counts of their public and professional activities (https://beyond-notability.wikibase.cloud/wiki/Item:Q151) | ## Women in our data alongside counts of their public and professional activities (https://beyond-notability.wikibase.cloud/wiki/Item:Q151) | ||
## Sorted by total PPAs | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
| Line 303: | Line 304: | ||
(count(distinct ?collect) as ?collected) | (count(distinct ?collect) as ?collected) | ||
(count(distinct ?performance) as ?performances) | (count(distinct ?performance) as ?performances) | ||
((?exhibitions + ?positions + ?spoke + ?attendance + ?donated + ?delegate + ?correspondents + ?fellowships + ?collaborations + ?founded + ?loans + ?illustrations + ?sales | |||
+ ?service + ?employed + ?fundraisers + ?published + ?benefactor + ?donor_to + ?collected + ?performances) AS ?PPA_total) | |||
where | where | ||
| Line 331: | Line 334: | ||
} | } | ||
group by ?person ?personLabel | group by ?person ?personLabel | ||
ORDER BY ? | ORDER BY DESC (?PPA_total) | ||
</sparql> | </sparql> | ||