query-dee056769762d5cceb1a0e01603aff64

rq turtle/ttl

title: Wie viele Objekte je Kunstmuseum (Q207694) sind auf Wikidata und wie viele Wikidata-Statements haben die Objekt-Items durchschnittlich?

SELECT ?mus ?musLabel ?objCount ?avgStatements WHERE {

{ SELECT ?mus (COUNT(?obj) AS ?objCount) (AVG(?c) AS ?avgStatements) WHERE { ?mus wdt:P31 wd:Q207694 . ?obj wdt:P276 ?mus; wikibase:statements ?c

   } GROUP BY ?mus ?musLabel }

FILTER ( ?objCount > 100) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY DESC(?avgStatements)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Wie viele Objekte je Kunstmuseum (Q207694) sind auf Wikidata und wie viele Wikidata-Statements haben die Objekt-Items durchschnittlich?

SELECT ?mus ?musLabel ?objCount ?avgStatements WHERE {

{
  SELECT ?mus (COUNT(?obj) AS ?objCount) (AVG(?c) AS ?avgStatements) WHERE {
  ?mus wdt:P31 wd:Q207694 .
  ?obj wdt:P276 ?mus;
       wikibase:statements ?c

       } GROUP BY ?mus ?musLabel }
  FILTER ( ?objCount > 100)
                             SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
                           }
ORDER BY DESC(?avgStatements)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?avgStatements"):::projected v5("?c") v3("?mus"):::projected v4("?obj") v6("?objCount"):::projected c3(["wd:Q207694"]):::iri c7(["bd:serviceParam"]):::iri c9(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["?objCount > '100^^xsd:integer'"]] f0 --> v6 v3 --"wdt:P31"--> c3 v4 --"wdt:P276"--> v3 v4 --"wikibase:statements"--> v5 bind3[/"count(?obj)"/] v4 --o bind3 bind3 --as--o v6 bind4[/"average(?c)"/] v5 --o bind4 bind4 --as--o v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end