SELECT count(DISTINCT temp01.person_account) AS "cadre_count" FROM (MATCH (person:/univ_demo/person WHERE status = '在职' AND age >= 36 AND age <= 45)-[:person_to_mgn_duty*1..1]->(mgn_duty:/univ_demo/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/person WHERE status = '在职' AND age >= 46 AND age <= 50)-[:person_to_mgn_duty*1..1]->(mgn_duty:/univ_demo/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/person WHERE status = '在职' AND age <= 35)-[:person_to_mgn_duty*1..1]->(mgn_duty:/univ_demo/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/person WHERE status = '在职' AND age >= 51)-[:person_to_mgn_duty*1..1]->(mgn_duty:/univ_demo/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) **/ ;