query-194f903286ddd26f289d7701b9ff7ddf

rq turtle/ttl

Occupations (sample)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT
  (?number_of_persons / ?total AS ?fraction) 
  ?occupation ?occupationLabel ?occupationDescription
WHERE {
   {
  SELECT 
    (COUNT(?person) AS ?number_of_persons)
    ?occupation
  WHERE {
     {
  SELECT 
    ?person
  WHERE {
    ?person wdt:P496 [] .
  }
  LIMIT 10000
}    ?person wdt:P106 ?occupation .
  }
  GROUP BY ?occupation
}   {
  SELECT 
    (SUM(?number_of_persons) AS ?total)
  WHERE {
     {
  SELECT 
    (COUNT(?person) AS ?number_of_persons)
    ?occupation
  WHERE {
    INCLUDE %persons
    ?person wdt:P106 ?occupation .
  }
  GROUP BY ?occupation
}    BIND(1 AS ?dummy)
  }
  GROUP BY ?dummy
}  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?number_of_persons)

Query found at