query-7df827f5c134e4260574659676d6607a

BIND, COUNTMinute : 42:19

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?an (COUNT(?q) AS ?compte) WHERE {
  ?q wdt:P1435 wd:Q9259 .
  ?q wdt:P571 ?date .
  BIND ( str(round(year(?date)/100)) AS ?an )
}
GROUP BY ?an

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; v3("?an"):::projected v4("?compte") v2("?date") v1("?q"):::projected c2(["wd:Q9259"]):::iri v1 --"wdt:P1435"--> c2 v1 --"wdt:P571"--> v2 bind0[/"str(numeric-round(year-from-dateTime(?date) / '100^^xsd:integer'))"/] v2 --o bind0 bind0 --as--o v3 bind2[/"count(?q)"/] v1 --o bind2 bind2 --as--o v4