odbtools/odbctest/mql/aianswer/321valido.mql

SELECT temp01.dept_sort AS "单位类别", avg(temp01.person_age) AS "平均年龄" FROM (MATCH (person:/univ_demo/person WHERE status = '在职')-[:person_to_org*1..1]->(org:/univ_demo/org) RETURN person.age AS "person_age", org.dept_sort_name AS "dept_sort") temp01 GROUP BY temp01."dept_sort" ORDER BY "平均年龄" DESC LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
count(8)
**/
;