odbtools/odbctest/mql/aianswer/333valido.mql

SELECT temp01.teacher_name AS "指导老师姓名", temp01.teacher_account AS "指导老师工号", temp01.org_name AS "所属院系", temp01.honor_name AS "荣誉名称", temp01.honor_level AS "荣誉级别", temp01.student_name AS "研究生姓名", temp01.student_account AS "研究生学号", temp01.paper_title AS "论文标题", temp01.paper_abstract AS "论文摘要", temp01.paper_level AS "论文等级", temp01.paper_type AS "论文类型", temp01.paper_keywords AS "论文关键词", temp01._univ_demo_paper_paper_file_0 AS "_univ_demo_paper_paper_file_0", temp01._univ_demo_paper_name_0 AS "_univ_demo_paper_name_0", temp01._univ_demo_szxxsb_hjdc_0 AS "_univ_demo_szxxsb_hjdc_0", temp01._univ_demo_szxxsb_name_0 AS "_univ_demo_szxxsb_name_0", temp01._univ_demo_szxxsb_sydw_0 AS "_univ_demo_szxxsb_sydw_0" FROM (MATCH (person:/univ_demo/person WHERE status = '在职' AND lx_date >= 1.577808e+12 AND age <= 45)-[:person_to_org*1..1]->(org:/univ_demo/org WHERE name = '计算机学院'), (person)-[:person_to_szxxsb*1..1]->(honor:/univ_demo/szxxsb WHERE gccrc in ('国家级人才A类', '国家级人才B类', '国家级人才C类', '省部级人才')), (person)-[:person_to_master*1..1]->(student:/univ_demo/student_master), (student)-[:own_paper*1..1]->(paper:/univ_demo/paper WHERE level in ('A类', 'B类') AND type in ('期刊', '会议') AND (title like '%人工智能%' OR abstract like '%人工智能%')) RETURN person.name AS "teacher_name", person.account AS "teacher_account", org.name AS "org_name", honor.xm_name AS "honor_name", honor.gccrc AS "honor_level", student.name AS "student_name", student.account AS "student_account", paper.title AS "paper_title", paper.abstract AS "paper_abstract", paper.level AS "paper_level", paper.type AS "paper_type", paper.keywords AS "paper_keywords", paper.paper_file AS "_univ_demo_paper_paper_file_0", paper.name AS "_univ_demo_paper_name_0", honor.hjdc AS "_univ_demo_szxxsb_hjdc_0", honor.name AS "_univ_demo_szxxsb_name_0", honor.sydw AS "_univ_demo_szxxsb_sydw_0") temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
matchcount("指导老师姓名", "熊剑", 1)
matchcount("研究生姓名", "赵敏", 1)
**/
;

SELECT count(temp01.paper_title) AS "paper_count" FROM (MATCH (person:/univ_demo/person WHERE status = '在职' AND lx_date >= 1.577808e+12 AND age <= 45)-[:person_to_org*1..1]->(org:/univ_demo/org WHERE name = '计算机学院'), (person)-[:person_to_szxxsb*1..1]->(honor:/univ_demo/szxxsb WHERE gccrc in ('国家级人才A类', '国家级人才B类', '国家级人才C类', '省部级人才')), (person)-[:person_to_master*1..1]->(student:/univ_demo/student_master), (student)-[:own_paper*1..1]->(paper:/univ_demo/paper WHERE level in ('A类', 'B类') AND type in ('期刊', '会议') AND (title like '%人工智能%' OR abstract like '%人工智能%')) RETURN paper.title AS "paper_title") temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
matchcount("paper_count", 1, 1)
**/
;