odbtools/odbctest/mql/aianswer/301valido.mql

MATCH (person:/univ_demo/person WHERE status = '离校' AND (person_sort = '事业编' OR staff_type = '校聘合同制人员') AND actual_quit_date >= '2024-01-01 00:00:00' AND actual_quit_date <= '2024-12-31 23:59:59')-[:person_to_org*1..1]->(org:/univ_demo/org) RETURN person.account AS "工号", person.name AS "姓名", person.actual_quit_date AS "离校日期", org.name AS "人事所在单位" ORDER BY actual_quit_date DESC WITH TIMEOUT = 6m
/**
output()
count(20)
**/
;