odbtools/odbctest/mql/uino/069.match_subquery.mql

MATCH (person:/univ_demo/person WHERE status = '在职' AND (polity = '中共党员' OR polity = '中共预备党员'))
-[:person_to_org*1..1]->
(org:/univ_demo/org) 
RETURN person.account AS "person_account", org.name AS "org_name" INTO /temp01_party_member_eb1a5b20-4177-4eed-89c8-77c800d6fc8b-0 WITH TIMEOUT = 5m
/**
output()
**/
;

{"sql":"SELECT temp01.org_name AS \"学院名称\", count(temp01.person_account) AS \"党员人数\" FROM /temp01_party_member_eb1a5b20-4177-4eed-89c8-77c800d6fc8b-0 temp01 GROUP BY temp01.\"org_name\" ORDER BY \"党员人数\" DESC LIMIT 0, 500000"}
/**
output()
count(82)
**/
;

SELECT temp01.org_name AS "学院名称", count(temp01.person_account) AS "党员人数" FROM 
(MATCH (person:/univ_demo/person WHERE status = '在职' AND (polity = '中共党员' OR polity = '中共预备党员'))
-[:person_to_org*1..1]->(org:/univ_demo/org) 
RETURN person.account AS "person_account", org.name AS "org_name") temp01 
GROUP BY temp01."org_name" ORDER BY "党员人数" DESC LIMIT 0, 500000 WITH TIMEOUT = 5m
/**
output()
count(82)
**/
;