Mean age per diagnosis group

Diagnosis	N	Mean Age
CONTROL	130	31.2615384615385
SCHZ	50	36.46
BIPOLAR	49	35.2857142857143
ADHD	43	33.093023255814

Run this query → no server · no download · no account

caviri.github.io/rete

Run this query in the playground → 4 rows · 7.0 ms · no server, no download — the query runs in your browser.

The query

PREFIX ncit: <http://ncitt.ncit.nih.gov/> SELECT ?diagnosis (COUNT(?s) AS ?n) (AVG(?age) AS ?meanAge) WHERE { ?s ncit:diagnosis ?diagnosis ; ncit:age ?age . } GROUP BY ?diagnosis ORDER BY DESC(?n)

rete playground · documentation · github.com/caviri/rete