odbtools/odbctest/mql/aianswer/326valido.mql

SELECT count(DISTINCT temp01.teacher_account) AS "a_level_teacher_count" FROM (MATCH (person:/univ_demo/person WHERE status = '在职' AND person_sort = '事业编' AND staff_type = '专任教师岗位')-[:person_to_szxxsb*1..1]->(szxxsb:/univ_demo/szxxsb WHERE jx_yjdj = 'A级') RETURN person.account AS "teacher_account") temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
matchcount("a_level_teacher_count", 168, 1)
**/
;

SELECT count(DISTINCT temp01.person_account) AS "teacher_count" FROM (MATCH (person:/univ_demo/person WHERE status = '在职' AND person_sort = '事业编' AND staff_type = '专任教师岗位')-[:person_to_szxxsb*1..1]->(szxxsb:/univ_demo/szxxsb) RETURN person.account AS "person_account") temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
matchcount("teacher_count", 845, 1)
**/
;