query-b1d747c05310a10ff66876ba6b328723

rq turtle/ttl

title: Total population in the Øresund Region

Illustrates the SUM aggregate function

SELECT DISTINCT ?area ?areaLabel (sum(?folkm_ngd) as ?total_folkm) # the first two variables can be removed # if only the number is needed WHERE { ?item wdt:P361 wd:Q297853. # part of (P361) Øresund Region (Q297853) ?item wdt:P1082 ?folkm_ngd. # 人口（P1082） ?area wdt:P31 wd:Q1907114. # instance of (P31) metropolitan area (Q1907114) ?area wdt:P527 ?item. # has part (P527) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } GROUP BY ?area ?areaLabel

Use at

• https://query.wikidata.org/sparql

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: <span lang="en" dir="ltr" class="mw-content-ltr">Total population in the Øresund Region</span>
# <span lang="en" dir="ltr" class="mw-content-ltr">Illustrates the SUM aggregate function</span>

SELECT DISTINCT ?area ?areaLabel (sum(?folkm_ngd) as ?total_folkm) # <span lang="en" dir="ltr" class="mw-content-ltr">the first two variables can be removed</span>
                                                                   # <span lang="en" dir="ltr" class="mw-content-ltr">if only the number is needed</span>
WHERE {
  ?item wdt:P361 wd:Q297853. # <span lang="en" dir="ltr" class="mw-content-ltr">part of (P361) Øresund Region (Q297853)</span>
  ?item wdt:P1082 ?folkm_ngd. # 人口（P1082）
  ?area wdt:P31 wd:Q1907114. # <span lang="en" dir="ltr" class="mw-content-ltr">instance of (P31) metropolitan area (Q1907114)</span>
  ?area wdt:P527 ?item. # <span lang="en" dir="ltr" class="mw-content-ltr">has part (P527)</span>
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
}
GROUP BY ?area ?areaLabel

Query found at

• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/zh