query-5091523c7b1b3bae7bba828dbee8b2e5

rq turtle/ttl

Versions of Windows ranked by the number of software titles that run on them

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#>
#defaultView:BubbleChart
SELECT ?app ?appLabel  (count (?software) as ?count)
WHERE {
  ?app (wdt:P279*) wd:Q1406.
  ?software wdt:P306 ?app.
  MINUS {?software wdt:P306 wd:Q1406.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

GROUP BY ?app ?appLabel 


ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?app"):::projected v4("?count") v3("?software"):::projected c5(["bd:serviceParam"]):::iri c2(["wd:Q1406"]):::iri c7(["en"]):::literal v2 --"wdt:P279"--> c2 v3 --"wdt:P306"--> v2 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v3 --"wdt:P306"--> c2 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c5 --"wikibase:language"--> c7 end bind2[/"count(?software)"/] v3 --o bind2 bind2 --as--o v4