query-67548004d8177af3abbc04f9a0d064ed

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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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 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. # population (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. # <span lang="en" dir="ltr" class="mw-content-ltr">population (P1082)</span>
  ?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/ar
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/be-tarask
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ca
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/cs
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/da
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/de
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/en-gb
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/eo
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/es
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/eu
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/he
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/hy
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/id
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/it
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ja
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ko
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/lb
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/lt
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ms
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/pl
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/pt-br
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ro
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ru
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/si
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/th
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/tr
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/uk
• https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/vec