query-0e537b8fc28c5ab92304edc5567bde60

rq turtle/ttl

For one cityTemplate for sectors. Replace placeholder XXX with the city id, e.g.: wd:2119 for Mannheim wd:Q64 for Berlin

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 ?sector ?sectorLabel (COUNT(?company) AS ?companyCount) WHERE {
  ?company (wdt:P31/(wdt:P279*)) wd:Q4830453;
    (wdt:P2868/(wdt:P279*)) wd:Q19287329;
    wdt:P159 XXX;
    wdt:P452 ?sector.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
}
GROUP BY ?sector ?sectorLabel

Query found at