query-5d39346a7c7379813a551b9b6006b9d5
Combined age of podium F1 at that moment in time. I started with one race, to implement the calculations so I could then easily extract it to all the races in the season and optionally to expanding to more seasons: (Q41174436)2020 Formula One World Championship Hey there, I'm trying to get a query to get the age of the podiumplaces (1st, 2nd and 3rd) together for each race in formula 1 season 2020
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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?rank ?dob ?eventtime ?age WHERE{
wd:Q67123914 p:P710 [ps:P710 ?item ; pq:P1352 ?rank].
wd:Q67123914 wdt:P585 ?eventtime.
?item wdt:P569 ?dob.
(?eventtime - ?dob) = ?age # how to calculate this? because this is giving an error.
Filter ( ?rank in (1, 2, 3)).
# and then finally sum the three ages together
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}