30select.mql 319 B

123456789101112131415
  1. select count(aaa.org_id) as count, aaa.org_id from
  2. (match (person:/univ_demo/person)-[:person_to_org]->(org:/univ_demo/org)
  3. return person.id as "person_id", org.id as "org_id") aaa
  4. group by aaa.org_id having count(distinct aaa.person_id)>=20
  5. /**
  6. output()
  7. count(1)
  8. match(org_id,"univ_demo_org:1",count,"1")
  9. **/
  10. ;