odbtools/odbctest/mql/aianswer/322valido.mql

SELECT temp01.tech_duty_level AS "专业技术职务级别", count(temp01.teacher_account) AS "专任教师人数" FROM (MATCH (person:/univ_demo/person WHERE status = '在职' AND person_sort = '事业编' AND staff_type = '专任教师岗位')-[:person_to_tech_duty*1..1]->(tech_duty:/univ_demo/tech_duty WHERE last_flag = '是') RETURN person.account AS "teacher_account", tech_duty.duty_level AS "tech_duty_level") temp01 GROUP BY temp01."tech_duty_level" LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
count(6)
matchcount("专业技术职务级别", "副高级", 1)
matchcount("专任教师人数", 362, 1)
matchcount("专业技术职务级别", "正高级", 1)
matchcount("专任教师人数", 319, 1)
**/
;

SELECT count(temp01.teacher_account) AS "teacher_count" FROM (SELECT person.account AS "teacher_account" FROM /univ_demo/person person WHERE person.status = '在职' AND person.person_sort = '事业编' AND person.staff_type = '专任教师岗位' LIMIT 0, 500000) temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
matchcount(teacher_count,1029,1)
**/
;