odbtools/odbctest/mql/aianswer_local/334valido.mql

SELECT count(DISTINCT temp01.person_account) AS "cadre_count" FROM (MATCH (person:/univ_demo_local/person WHERE status = '在职' AND age >= 36 AND age <= 45)-[:person_to_mgn_duty*1..1]->(mgn_duty:/univ_demo_local/mgn_duty WHERE xzzw_sx = '主职' AND last_flag = '是' AND level in ('正处级', '副处级')) RETURN person.account AS "person_account") temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
matchcount("cadre_count", 81, 1)
**/
;

SELECT count(DISTINCT temp01.person_account) AS "cadre_count" FROM (MATCH (person:/univ_demo_local/person WHERE status = '在职' AND age >= 46 AND age <= 50)-[:person_to_mgn_duty*1..1]->(mgn_duty:/univ_demo_local/mgn_duty WHERE xzzw_sx = '主职' AND last_flag = '是' AND level in ('正处级', '副处级')) RETURN person.account AS "person_account") temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
matchcount("cadre_count", 55, 1)
**/
;

SELECT count(DISTINCT temp01.person_account) AS "leader_count" FROM (MATCH (person:/univ_demo_local/person WHERE status = '在职' AND age <= 35)-[:person_to_mgn_duty*1..1]->(mgn_duty:/univ_demo_local/mgn_duty WHERE xzzw_sx = '主职' AND last_flag = '是' AND level in ('正处级', '副处级')) RETURN person.account AS "person_account") temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
matchcount("leader_count", 7, 1)
**/
;

SELECT count(DISTINCT temp01.person_account) AS "cadre_count" FROM (MATCH (person:/univ_demo_local/person WHERE status = '在职' AND age >= 51)-[:person_to_mgn_duty*1..1]->(mgn_duty:/univ_demo_local/mgn_duty WHERE xzzw_sx = '主职' AND last_flag = '是' AND (level = '正处级' OR level = '副处级')) RETURN person.account AS "person_account") temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
matchcount("cadre_count", 78, 1)
**/
;