Difference between revisions of "What is the proportion of presidents who have died in held position? (Q440)"

SELECT (COUNT(?obj3) / COUNT(DISTINCT ?sbj) AS ?ratio) WHERE { { SELECT DISTINCT ?sbj ?obj3 WHERE { ?sbj p:P39 ?obj1 . ?obj1 ps:P39 ?obj2 . ?obj2 wdt:P31?/wdt:P279* wd:Q30461 . OPTIONAL { ?obj1 pq:P1534/wdt:P279* ?obj3 . FILTER(?obj3 = wd:Q99521170) } } } }