query-717f39d2b07366869bb16509bf11a401

rq turtle/ttl

Propertiesinstance of (P31)sex or gender (P21)country of citizenship (P27)field of work (P101)occupation (P106)

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#>
SELECT ?occupation ?occupationLabel (COUNT(?item) AS ?count) WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl,fr,de,en". }
  ?item wdt:P31 wd:Q5, ?instance;
    wdt:P21 wd:Q6581072, ?gender;
    wdt:P27 wd:Q31, ?nationality;
    wdt:P101 wd:Q184485, ?domain;
    wdt:P106 ?occupation.
}
GROUP BY ?occupation ?occupationLabel
ORDER BY (?occupationLabel)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v8("?count") v6("?domain") v4("?gender") v3("?instance") v2("?item"):::projected v5("?nationality") v7("?occupation"):::projected v1("?occupationLabel"):::projected c10(["wd:Q31"]):::iri c8(["wd:Q6581072"]):::iri c4(["#91;AUTO_LANGUAGE#93;,nl,fr,de,en"]):::literal c12(["wd:Q184485"]):::iri c2(["bd:serviceParam"]):::iri c6(["wd:Q5"]):::iri subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c2 --"wikibase:language"--> c4 end v2 --"wdt:P31"--> c6 v2 --"wdt:P31"--> v3 v2 --"wdt:P21"--> c8 v2 --"wdt:P21"--> v4 v2 --"wdt:P27"--> c10 v2 --"wdt:P27"--> v5 v2 --"wdt:P101"--> c12 v2 --"wdt:P101"--> v6 v2 --"wdt:P106"--> v7 bind1[/"count(?item)"/] v2 --o bind1 bind1 --as--o v8