query-a7afb02c2b5a2c209af9e266d9d9ccc8

FLOOR

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#defaultView:Map
SELECT * WHERE {
  ?dpt wdt:P31 wd:Q6465 .
  ?dpt wdt:P3896 ?form .
  ?dpt wdt:P1082 ?pop .
  BIND ( FLOOR (?pop/1000000) AS ?layer )
}

Query found at

https://www.wikidata.org/wiki/Wikidata:Events/Faisons_des_%C3%A9tincelles_avec_SPARQL

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?dpt"):::projected v2("?form"):::projected v4("?layer"):::projected v3("?pop"):::projected c2(["wd:Q6465"]):::iri v1 --"wdt:P31"--> c2 v1 --"wdt:P3896"--> v2 v1 --"wdt:P1082"--> v3 bind0[/"numeric-floor(?pop / '1000000^^xsd:integer')"/] v3 --o bind0 bind0 --as--o v4