PREFIX xsd: PREFIX schema: PREFIX rdf: PREFIX rdfs: PREFIX iisgv: PREFIX iisgv2: PREFIX gg: PREFIX geo: PREFIX bio: SELECT ?age (?1910/xsd:decimal(?total_1910)*100 as ?share_1910) (?november_1918/xsd:decimal(?november_1918_total)*100 as ?share_november_1918) (?winter_1919/xsd:decimal(?winter_1919_total)*100 as ?share_winter_1919) WHERE { { select ?total_1910 ?age ?november_1918_total ?winter_1919_total (sum(if(?year = "1918"^^ && ?month = 11, 1, 0)) as ?november_1918) (sum(if(?year = "1910"^^, 1, 0)) as ?1910) (sum(if(?year = "1919"^^ && ?month >= 3, 1, 0)) as ?winter_1919) { ?death a bio:Death . ?death iisgv:deceased ?deceased . ?deceased schema:gender "f" . # add sex to query ?deceased iisgv:ageYears ?age. ?death bio:date ?date . BIND(year(?date) as ?year) BIND(month(?date) as ?month) FILTER(?age > 0) # excluded because there may still be an issue with age=0 { select (sum(if(?year = "1910"^^, 1, 0)) as ?total_1910) (sum(if(?year = "1918"^^ && ?month = 11, 1, 0)) as ?november_1918_total) (sum(if(?year = "1919"^^ && ?month >= 3, 1, 0)) as ?winter_1919_total) { ?death a bio:Death . ?death iisgv:deceased ?deceased . #?deceased schema:gender "m" . ?deceased iisgv:ageYears ?age. ?death bio:date ?date . BIND(year(?date) as ?year) BIND(month(?date) as ?month) FILTER(?age > 0) # excluded because there may still be a slight issue with age=0 }} } }} ORDER BY ASC (?age)

Documentation

Triply