count_wd_by_gnd_class.rq

# Count Wikidata items linked to GND by GND class
#
PREFIX gndo: <https://d-nb.info/standards/elementset/gnd#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
#
select distinct ?gndoClass ?gndoClassLabel
(str(count(distinct ?gnd)) as ?gndCount)
(str(sum(?inWd)) as ?wdCount)
(concat(str(round((sum(?inWd)/count(distinct ?gnd))*1000)/10), ' %') as ?percentage)
where {
  {
    service <https://query.wikidata.org/bigdata/namespace/wdq/sparql> {
      ?wd wdt:P227 ?gndId .
      filter (isLiteral(?gndId))
    }
    bind (uri(concat('https://d-nb.info/gnd/', ?gndId)) as ?gnd)
    ?gnd a ?gndoClass .
    bind(1 as ?inWd)
  } union {
    ?gnd a ?gndoClass .
    filter(strstarts(str(?gndoClass), str(gndo:)))
    bind(0 as ?inWd)
  }
  bind(strafter(str(?gndoClass), str(gndo:)) as ?gndoClassLabel)
}
group by ?gndoClass ?gndoClassLabel
order by desc(count(distinct ?gnd))