User:PAC2/Cancel Gérard
#title: Average age of people supporting Depardieu
SELECT (AVG(?age) AS ?agemean) WHERE {
wd:Q124005357 wdt:P577 ?publication;
wdt:P1891 ?signataire.
?signataire wdt:P569 ?naissance.
BIND((YEAR(?publication)) - (YEAR(?naissance)) AS ?age)
}
#title: Average age of people supporting Depardieu
SELECT (AVG(?age) AS ?agemean) WHERE {
wd:Q124005357 wdt:P577 ?publication;
wdt:P1891 ?signataire.
?signataire wdt:P569 ?naissance.
BIND((?publication - ?naissance)/365.25 AS ?age)
}
#title: Total numberof awards of people supporting Depardieu
SELECT ?award ?awardLabel (COUNT(*) AS ?count) WHERE {
wd:Q124005357 wdt:P577 ?publication;
wdt:P1891 ?signataire.
?signataire wdt:P166 ?award.
?award rdfs:label ?awardLabel.
FILTER((LANG(?awardLabel)) = "[AUTO_LANGUAGE]")
}
GROUP BY ?award ?awardLabel
ORDER BY DESC (?count)