query-861432f7b4d7c5f070b63c9b70b4df15

rq turtle/ttl

title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions) title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location .

FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: <span lang="en" dir="ltr" class="mw-content-ltr">Distinct billionaires</span>
SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions)
WHERE
{
  ?item wdt:P2218 ?worth.
  ?item wdt:P19 ?location .

  FILTER(?worth>1000000000).
  BIND(?worth/1000000000 AS ?billion).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". }
}
GROUP BY ?locationLabel ?item ?itemLabel
ORDER BY DESC(?billions)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?billion"):::projected v6("?billions") v3("?item"):::projected v4("?location") v2("?worth") c5(["bd:serviceParam"]):::iri c7(["en,de"]):::literal f0[["?worth > '1000000000^^xsd:integer'"]] f0 --> v2 v3 --"wdt:P2218"--> v2 v3 --"wdt:P19"--> v4 bind1[/"?worth / '1000000000^^xsd:integer'"/] v2 --o bind1 bind1 --as--o v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c5 --"wikibase:language"--> c7 end bind3[/"max(?billion)"/] v5 --o bind3 bind3 --as--o v6