odbtools/odbctest/mql/aianswer/313valido.mql

MATCH (person:/univ_demo/person WHERE (person_sort = '事业编' OR staff_type = '专任教师岗位') AND degree_level != '博士' AND status = '在职')-[:person_to_tech_duty*1..1]->(tech_duty:/univ_demo/tech_duty WHERE duty = '教授' AND last_flag = '是') RETURN person.name AS "name", person.account AS "account", person.subject_first AS "subject_first", person.subject_second AS "subject_second", person.xw_dept AS "xw_dept", tech_duty.jj_time_start AS "promotion_time", tech_duty.name AS "_univ_demo_tech_duty_name_0", tech_duty.duty AS "_univ_demo_tech_duty_duty_0" WITH TIMEOUT = 6m
/**
output()
count(30)
**/
;