odbtools/odbctest/mql/aianswer/312valido.mql

SELECT temp01.teacher_name AS "姓名", temp01.teacher_account AS "工号", temp01.teacher_age AS "年龄", temp01.teacher_degree AS "学位层次", temp01.teacher_title AS "职称", temp01._univ_demo_tech_duty_name_0 AS "_univ_demo_tech_duty_name_0" FROM (MATCH (person:/univ_demo/person WHERE status = '在职' AND person_sort = '事业编' AND staff_type = '专任教师岗位' AND subject_first = '马克思主义理论')-[:person_to_tech_duty*1..1]->(tech_duty:/univ_demo/tech_duty WHERE last_flag = '是') RETURN person.name AS "teacher_name", person.account AS "teacher_account", person.age AS "teacher_age", person.degree_level AS "teacher_degree", tech_duty.duty AS "teacher_title", tech_duty.name AS "_univ_demo_tech_duty_name_0") temp01 ORDER BY temp01."teacher_age" DESC LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
count(41)
**/
;